ISNUMBER
 

Hi

I want to be able to check two cells at once to see if they contain a number
and then do a calculation based on whether they do or don't. The problem is
the ISNUMBER function does not seem to be able to check two cells at once.

Is there any way around this?

Thanks Michael

ISNUMBER
 

Michael Nol wrote...
I want to be able to check two cells at once to see if they contain a number
and then do a calculation based on whether they do or don't. The problem is
the ISNUMBER function does not seem to be able to check two cells at once.

Is there any way around this?

COUNT(OneCell,AnotherCell)=2