IF Statement won't work

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!
 
L

Lee Schipper

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
 
J

JE McGimpsey

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

Ragdyer

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)
 
C

Caliban

D'oh!

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

Much appreciated!
 
Top