If statements

[JasonP]

Hi

Is there a formula that can say for example, if the cells in A1:C1 = 0 and D1 =>0 then Gain if not loss?

Any help would be gratefully received

Thanks in advance

 

[texasalynn]

=IF(AND(A1:C1=0,D1>=0),"Gain","Loss")

 

[JasonP]

Many Thanks

Jason

 

[JasonP]

Hi

Is there a way of saying for example, if the value in A1, B1, C1 (but not as a sum) are all greater than 0 and the sum of D1:G1 = 0 then "loss"?

Any help would be gratefully received

Thanks in advance

Regards

Jason

 

[njimack]

=IF(AND(A1=0,B1=0,C1=0,SUM(D1:G1)=0),"loss")