conditional, lookup and reference formulas

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

Guest

Hi,

None of the conditional, lookup and reference formulas want to work in my
Excel 2007 installation. Adding the following formula using the wizard:
=if(1 "ok" "error") returns the error "The formula you typed contains an
error.".

The usual syntax would be =if(1,"ok","error") but for some reason the comma
is now a space?

What's up?
Please help.
 
Amanda,
You must have a logical statement for this to work.
"=IF(some cell =1,"OK","ERROR")
hth
 
Back
Top