| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ignore #N/A in a formula
Archana,
you can use =IF(A2=#N/A,"",((A2*A3)+(B2*B3)+(C2*C3))/A1)) " wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
