Limit to IFs ???
 

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

Limit to IFs ???
 

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

Limit to IFs ???
 

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" wrote in message
...
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

Limit to IFs ???
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"RustyR" schrieb im Newsbeitrag
...
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" wrote in message
...
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