Formula > 0

  • Thread starter Thread starter KC
  • Start date Start date
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.
 
=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
 
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)
 
Back
Top