ISNUMBER

[Michael Nol]

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

[Harlan Grove]

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