Impact
~650
people reached
- 0 posts edited
- 0 helpful flags
- 0 votes cast
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 |