11 reputation
1
bio website
location
age
visits member for 1 year, 11 months
seen Jul 24 '12 at 11:25

Jul
23
comment How to have a cell calculate only once
O29 does have a formula. We'd be checking to see if Q32 = Y. O32 is running a calculation as well. SO in words. If Q29 = y and Q32=N then N29 continue calculating realtime; O29 and O32 = 0.. If Q29 and Q32 both = Y then N29=0, O29=N29 last Value, O32= N29 last value (or last calculation).
Jul
18
comment How to have a cell calculate only once
here to clarify. Cell O29 is calculating realtime profit and loss while a position is open, all calculated on row 29. Once the position is closed on row 32, Cell Q32=Y, (Has no formula but other cells reference cell Q looking to see if it's Y or not.. Cell O32 amd Cell O29 should equal to 0 and the profit and loss should only calculate once in cell O32. Hope this helps.. thank you all in advance
Jul
17
comment How to have a cell calculate only once
No Q29 doesn't have a formula. Here is what i have: Cell Q29 can either be yes or no. the yes or no will determine the value of N29=IF(OR(AND(G29="s",G32="b",Q29="y",Q32="y"),AND(G29="b",G32="s",Q29="y",Q32="‌​y")),0,((L29*M29)-(I29*M29))/L29) ----and here is the formula for the other cell 0 =IF(N29=0,((L29*M29)-(I29*M29))/L32+((L32*M32)-(I32*M32))/L32) --- I agree that the calculations can be moved to a macro. but how? Thanks!
Jul
17
comment How to have a cell calculate only once
Yes if need be. Anything is greatly appreaciated.
Jul
17
awarded  Student
Jul
17
asked How to have a cell calculate only once