Help with IF THEN Formula

C

cdegar01

I am having trouble with this formula:

=IF([Book2]Sheet1!B1=0,"NA",[Book2]Sheet1!B1)


Typically, if the cell is blank or has a zero in it, it will retur
"NA." Now, however, if the cell to the left of it has a value in i
([book2]sheet1!A1), then it will return a blank and not "NA." If th
cell to the left of it does not have a value, it will return "NA."

This is confusing and frustrating. Any help is appreciated.

Thanks,

Chri
 
R

RagDyer

What is the formula in B1?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

I am having trouble with this formula:

=IF([Book2]Sheet1!B1=0,"NA",[Book2]Sheet1!B1)


Typically, if the cell is blank or has a zero in it, it will return
"NA." Now, however, if the cell to the left of it has a value in it
([book2]sheet1!A1), then it will return a blank and not "NA." If the
cell to the left of it does not have a value, it will return "NA."

This is confusing and frustrating. Any help is appreciated.

Thanks,

Chris
 
C

cdegar01

B1 would either be blank or a number. There are no formulas. The thin
is, that formula that I am using works most of the time, but now it ha
decided not to work.

Thanks,

Chri
 
D

Dave Peterson

Any chance that there's text in B1?

Lotus 123 and Excel can treat these differently.

Try tools|options|transition tab|
uncheck transition formula evaluation (if it's checked).

In fact, I've unchecked all these transition settings.

=======
One more guess: Are you sure the cell is really blank? Maybe there's a space
character or even just a simple apostrophe (') in it.

If you select that cell and hit the delete key, does your formula evaluate ok?
 
Top