View Single Post
  #2   Report Post  
OZDOC1050
 
Posts: n/a
Default

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

--
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
"Akbar uk" wrote in message
...
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