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
|