View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Help with formula, pls

One way:

=COUNT(A1:A5)=5

In article ,
J.Alex. wrote:

Hi,

Is there a way to check for numbers in a range of cells? Ie, to do a kind of
ISNUMBER(A1:A5)?

Thanks,