How to set a formula if the value is with #N/A
You could use:
=sum(b2:c2)
as sum will ignore text.
However if the #N/A you are displaying is the result of an Excel formula,
then Sum won't work. In this case, you are better off to avoid the #N/As in
the first place, typically done with:
=if(isna(yourformula),0,yourformula)
Regards,
Fred
"lee-sc" wrote in message
...
Example :
E/no salary Bonus total
001 1000 #N/A
002 200 100
003 2000 #N/A
How to set a formula for each worker in total column (Salary & Bonus)when
the value are set as #N/A. How to convert #N/A to 0 for sum formula.
Please advise.
Thanks.
|