ISNUMBER

  • Thread starter Thread starter Michael Nol
  • Start date Start date
M

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
 
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?
Click to expand...

COUNT(OneCell,AnotherCell)=2
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct(match range of values in 2+ cols) 15
using SUMIF with ISNUMBER 6
If with countif or counta 3
If and Countif 2
Nested Functions Limit 8
subtracting date/time 8
Excel If statement copy only if ISNumber result is yes 1
Complex conditional summing - array COUNT works, array SUM gives#VALUE 4

Back
Top