View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Help with formula, pls

Maybe

=IF(ROWS(A1:A10)=COUNT(A1:A10),TRUE,FALSE)

Mike

"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,