View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] dfuribe@gmail.com is offline
external usenet poster
 
Posts: 3
Default If statement for a range of cells

Hi, I want to know if it is possible to create an IF statement that can for example give a TRUE value if all the cells in the range A1 to C50 are greater or equal to 0 and FALSE otherwise.

I have tried IF((A1:C50)=0,TRUE,FALSE), but it does not work.

Thanks for your help,

Daniel