show zero if the velue is in -

A

Akbar uk

I want to create a field which show zero if the velue of the other filed is -
like, a1+ a2+ a3= B2 if the total of these field is in - so it show 0 in B2.

Thanks
 
O

OZDOC1050

Hope i have your Q right

=if( a1+a2+a3<0,0,a1+a2+a3)
or
=if(sum(A1:A3)<0,0,sum(A1:A3))

HTH
 
Top