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 calcula...
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.