Hi
the cell is probably formated as 'Text'. Goto 'Format - Cells', change
the format to 'General' and re-enter your formula

--
Regards
Frank Kabel
Frankfurt, Germany

"RustyR" schrieb im Newsbeitrag
...
Hi all,

I have a workbook with 4 sheets.
The first three are filled with data and I am using the 4th sheet to
lay out
that data in a flatfile for import into access.
I always try to make sure there is a value like: =IF(Requestor!G41 =
"","",Requestor!G41)
This way, I don't get pesky Zeros.
However, I am at column AS and when I type in the above formula, the
cell
actually displays that formula. The same for every column after that.
So, is there a limit to the number of columns you can use the IF
statement
in? Or am I just missing something??

Thank you in advance, you all are a wealth of info!

Rusty