Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF ERROR FORMULA
=IFERROR(N2,O2),IFERROR(O2,P2),IFERROR(P2,Q2),IFER ROR(Q2,R2),"0"
I am using this formula in Column I to Check rows N, O, P,Q, and R to copy the dollar amount that is in one of the four fields. There is never an instance where there is a dollar amount in more than one field and if there is no dollar figure in any of the fields I would like it to come back as a zero. Please help me to figure out what I am doing wrong. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF ERROR FORMULA
You can't simply string functions together like that, seperated by commas.
However, you could use this array* formula: =SUM(IF(ISNUMBER(N2:R2),N2:R2)) *Array formulas must be confirmed using Ctrl+Shift+Enter, not just Enter. -- Best Regards, Luke M "Candida" wrote in message ... =IFERROR(N2,O2),IFERROR(O2,P2),IFERROR(P2,Q2),IFER ROR(Q2,R2),"0" I am using this formula in Column I to Check rows N, O, P,Q, and R to copy the dollar amount that is in one of the four fields. There is never an instance where there is a dollar amount in more than one field and if there is no dollar figure in any of the fields I would like it to come back as a zero. Please help me to figure out what I am doing wrong. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula returns error; abbreviating the formula | Excel Discussion (Misc queries) | |||
Formula error | New Users to Excel | |||
Formula Error | Excel Worksheet Functions | |||
Formula Error | Excel Worksheet Functions | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions |