IF Statement won't work

  • Thread starter Thread starter Caliban
  • Start date Start date
C

Caliban

I am trying to include an IF statement on a spreadsheet using Excel 97, but
the programme always interprets it as a text statement. I'm using the syntax
IF(B4>A3,D1,0) or (test,value if true,value if false) which appears to be
correct but the problem won't go away. Any ideas?

Thanks in advance!
 
Did you type an = sign in front of the IF?

=IF(B4>A3,D1,0)

The = tells Excel this is an expression, not a string.


Lee Schipper
 
Check that

1) you used an = sign to start the formula, and

2) That your cell is formatted as General or another Number format. IF
it's formatted as Text, XL will interpret as Text and not evaluate it.
 
Are you saying that the formula itself is being displayed in the cell,
instead of the calculated result?

If that be the case, one of these should work:

Select the cell with the "bad" formula and,
<Ctrl> <Shift> <~>
Then <F2>
Then <Enter>
OR
<Ctrl> <~>
OR
Make sure that there's an equal (=) sign to beginning of formula.
=IF(B4>A3,D1,0)
 
D'oh!

Thank you guys! The Help file did not include the "=" sign in it's syntax.

Much appreciated!
 
Back
Top