Formula Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This may just be a simplification of a previous question but I am still having problems. I am using the following IF statement atempting, if the statement is true, to get a calculation out, however I am getting only text

IF(A1-30>0,"A1-30","0"

Assuming A1 is 32 than I get (A1-30) instead of the desired value (2)
 
Hi Kyle
Remove the " " from formula, they are used to enter text.
Your formula is saying if True enter text A1-30, if False
enter text 0.

Regards Bob C

-----Original Message-----
This may just be a simplification of a previous question
Click to expand...
but I am still having problems. I am using the following
IF statement atempting, if the statement is true, to get
a calculation out, however I am getting only text.
 
Back
Top