Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set a formula if the value is with #N/A
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. |