Thread: IF and SUM
View Single Post
  #2   Report Post  
Old May 17th 05, 03:39 PM
JE McGimpsey
 
Posts: n/a
Default

One way:

=IF(SUM(A1:E1)1,1,0)

or, more compactly (using the fact that XL coerces TRUE/FALSE to 1/0 in
math operations):

=--(SUM(A1:E1)1)

where the first - coerces TRUE/FALSE to -1/0, and the second back to 1/0.


In article ,
"Natalie" wrote:

How do I say

If the sum of A1:E1 is greater than 1, enter a 1 in the column, but if not
then enter a 0?