I am trying to create an IF formula that works with the following parameters:
A1= 20
A2= (A1*.5)
A3=X
I've written a formula for A4 that does not work as I'd like: =IF(A3="X","A2*1.1",0)
The desired function for cell A4 is if A3 is X, then the value in A4 is (A2*1.10) which should equal 11. However, this formula as I've written it results in "A2*1.1" reporting the cell as text but without the calculation taking place. Is there a way to make the formula in cell A2 calculate values I need while inside the formula in A4 so it reports back the value "11" instead of "A2*1.1"?
Thanks
Bookmarks