IF statements

  • Thread starter Thread starter Sheetal
  • Start date Start date
S

Sheetal

I am creating an IF statement. I have a load of blank cells in m
spreadsheet, and i want them to return a value of 0. All the othe
cells have numbers in them.

My IF statement to replace the blank cells is: =if(f3="",0,"").

What is wrong with this statement? Excel won't accept it!

Thank you

Sheeta
 
What error do you get? the formula works for me (assuming the period
was the end of your sentence, not part of the formula) unless I try
to enter it in F3, in which case XL gives a circular reference error.

Some other possibilities:

1) You have the R1C1 reference mode set, in which case XL should
accept the formula, but return a #NAME! error.

2) F3 contains an error result, in which case XL should accept the
formula, but return the error.

3) Your version of XL uses semicolons rather than commas as
separators, in which case you should get a syntax error.
 
Back
Top