Hi,

Try this - IF(J160,IF(ISNUMBER(B16),B16,A16))

Regards,

Ashish Mathur

"Jim" wrote:

Hi Everyone.

I am using Excel 2000.

I have an IF formula. It first looks to see if J160. If it is, I want it to
look at B16 and see if there is any number including zero (0) in the cell. If
there is, it is to use B16, if not it is to use cell A16.

If I use IF(B16=0), it returns true even if B16 is empty or blank. When B16
is empty or blank, I need the formula to go to A16.

Can someone help?
Thanks
--
Jim