If statement for a range of cells
wrote in message
...
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
|