Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore #N/A in a formula
Hi I have the following formula
=((A2*A3)+(B2*B3)+(C2*C3))/A1 how can I get the result ignoring #N/A for example if A2 = #N/A Please help Thanks Archana |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore #N/A in a formula | Excel Discussion (Misc queries) | |||
Ignore Text for Formula | Excel Discussion (Misc queries) | |||
How do i ignore letters in a formula? | Excel Worksheet Functions | |||
How can I ignore an #N/A value in a =SUM() formula? | Excel Worksheet Functions | |||
USING IGNORE BLANKS IN FORMULA | Excel Discussion (Misc queries) |