Forum Discussion
IF/Then formula
I am trying to use an If/Then formula to calculate a value. I'm using this: =IF(A8< 5000.01,C8=A8*0.05).
The cell that contains the formula is showing "FALSE". I want cell C8 to contain the calculated number. What am I doing wrong?
Thanks.
7 Replies
WMegl In C8 enter:
=IF(A8< 5000.01,A8*0.05,"something else")
.... where you can replace "something else" with whatever you want to display if A8 is NOT less then 5000.01.
- I got it to work. I needed the add the THEN formula. Thanks.
- Neither of the formulas above worked. I'm still getting the word "FALSE: in the cell rather than a value.
WMegl Why not upload a screenshot of your worksheet showing the formula "at work".
- =IF(A8< 5000.01;A8*0.05;"")
