Prev: Can I use "OR" in two auto-filters/custom filters?
Next: CONVERT HOURS AND MINUTES TO INT
From: Candida on 24 May 2010 11:44
=IFERROR(N2,O2),IFERROR(O2,P2),IFERROR(P2,Q2),IFERROR(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.
From: Luke M on 24 May 2010 13:15
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" <Candida(a)discussions.microsoft.com> wrote in message
news:C8D8D8AF-7EB0-4622-BBBF-6D5B508F6876(a)microsoft.com...
> =IFERROR(N2,O2),IFERROR(O2,P2),IFERROR(P2,Q2),IFERROR(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.


 | 
Pages: 1
Prev: Can I use "OR" in two auto-filters/custom filters?
Next: CONVERT HOURS AND MINUTES TO INT