Home |
Search |
Today's Posts |
#1
|
|||
|
|||
show zero if the velue is in -
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no show all function in dropdown list in Pivot Table | Excel Discussion (Misc queries) | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Show a date based on today | Excel Worksheet Functions |