OK, so im trying to figure out how to use the IF statement to determine if cell A1 with 1/08/2014 in it is >= todays date. If true then cell (A2 = A2 - A3), if false (A2=A2).
Am I going about this all wrong?
Hope I make sense
Thanks
Jonny
OK, so im trying to figure out how to use the IF statement to determine if cell A1 with 1/08/2014 in it is >= todays date. If true then cell (A2 = A2 - A3), if false (A2=A2).
Am I going about this all wrong?
Hope I make sense
Thanks
Jonny
You will get circular reference for the formula A2 = A2 - A3 because you can not reference the formula cell in the formula itself.
The IF statement can be written as
In the formula you can replace "Calculation if True" with whatever you want to do if the condition is evaluated to True and replace "Calculation if False" with whatever you want to do if the condition is evaluated to False.Please Login or Register to view this content.
Does this help?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thats great thank!
Its the whole not being able to reference the forumla cell in the formula itself that through me off. Ive fixed it now though
Thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks