| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Offset/Match formula returns "#N/A"
I have the following formula:
=-OFFSET(INPUT!$A$1,MATCH(April!$I$8,INPUT!$A$2:$A$3 9,0),MATCH(April!A18,INPUT!$B$1:$AF$1,0))+OFFSET(I NPUT!$A$1,MATCH(April!$I$9,INPUT!$A$2:$A$39,0),MAT CH(April!A18,INPUT!$B$1:$AF$1,0))+OFFSET(INPUT!$A$ 1,MATCH(April!$I$11,INPUT!$A$2:$A$39,0),MATCH(Apri l!A18,INPUT!$B$1:$AF$1,0)) If one of the Offset/Matches returns "#N/A", then the entire formula is "#N/A". How can I fix it that if one (or two or three) returns "#N/A", I still get the sum of the other two (or one or "0")? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to not count cells which contain a formula that returns " "? | Excel Worksheet Functions | |||
| Formula for Multiple "IF's" or maybe "COUNTIF's"??? | Excel Discussion (Misc queries) | |||
| How do I use "offset" function in "array formula"? | Excel Discussion (Misc queries) | |||
| Formula format in excel that returns an "error" if there is a blan | Excel Discussion (Misc queries) | |||
| "IF" formula returns zero or other incorrect number | Excel Worksheet Functions | |||
Threaded Mode
