View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Candida Candida is offline
external usenet poster
 
Posts: 27
Default 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.