LinkBack URL
About LinkBacks
if a2="2" then add 120 to data in cell b2.
This should be simple, but I am just not able to wrap my head around it toady.
if a2="2" then add 120 to data in cell b2.
This should be simple, but I am just not able to wrap my head around it toady.
It would be
= IF(A2 = 2, B2 + 120, B2)
But a formula cannot reference it's own cell as part of the calculation otherwise you get a Circular Reference error. You can only have the formula in another cell other than B2.
Or maybe I read it wrong and the formula is in another cell; If so, then that is the formula.
It's getting late...
Last edited by cytop; 02-22-2017 at 06:30 PM.
Just for fun
Enable iterative calculation (Option => Formulas)
Set maximum iterations: 1
A2: =IF(B2=120,0,2)
B2: =IF(A2=2,A2+120,0)
Refresh
Hello herbie000 & Welcome to the Forum,
Administrative Note:
- We would love to continue to help you with your query, but first, before we can proceed…
- Please see Forum Rule #1 about proper thread titles and adjust accordingly...
Last edited by jeffreybrown; 02-22-2017 at 07:47 PM.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks