Formula > 0

K

KC

I'm having trouble coming up with the right formula.

If the range C8:C13 is >0, then return a 1 in the cell, otherwise return 0
in the cell.
 
G

Gary''s Student

=IF(MAX(C8:C13)>0,1,0)
If you mean ANY cells in the range are greater than zero.


If you mean ALL the cells are greater than zero, then use MIN instead of MAX
 
J

joeu2004

I'm having trouble coming up with the right formula.
If the range C8:C13 is >0, then return a 1 in the cell,
otherwise return 0 in the cell.
Click to expand...

What do you mean by "if the range > 0": if the sum of the range; if
each cell is zero; or if any one cell is zero?

For the sum:

=if(sum(C8:C13) > 0, 1, 0)
 
Top