If the sum of a range is equal to or less than the sum

I need help creating a formula for the following cell A4.

If the sum of A1,A2 & A3 is 3 then A4 will show the sum of 1.

If the sum of A1,A2 & A3 is less than 3 then A4 will show the sum of 0.

Thanks for any help.

Nick

And what happens i the sum is >3 ?

Originally Posted by arthurbr

And what happens i the sum is >3 ?

The sum can't be more than 3 as there will be a selection drop down for each cell not allowing more than a total of 1 per cell.

Thanks TMShucks, that worked perfect.

=IF(SUM(A1:A3)=3,1,IF(SUM(A1:A3)<3,0,"not specified"))

Regards

If you have only 0's and 1's you can enter =a1*a2*a3