Limit to IFs ???

[RustyR]

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

 

[Frank Kabel]

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

 

[RustyR]

Thanks for the help - I had already tried formatting the cell to General but
I still got the same error - BUT, when I changed the cells adjacent to it to
General - it worked!
\
Thank you!

Rusty

 

[Frank Kabel]

Hi
you have to re-enter the formula after changing the format as well