conditional, lookup and reference formulas

A

Amanda

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

FloMM2

Amanda,
You must have a logical statement for this to work.
"=IF(some cell =1,"OK","ERROR")
hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference Cell Altering Formulas 1
Conditional Formatting Based On Formula Values 2
Extremely slow calculation of formulas 4
Data validation and Arrays 0
Mapping integers to strings 6
Replace 1
Conditional Formatting - to highlight overwritten formulas 13
Error message for comparison formulas 1

Top