using 2 or more functions together

  • Thread starter Thread starter jana
  • Start date Start date
J

jana

I have a formula that needs a little tweeking but i don't
know how to make it do it.

I have cell E1=IF(A1=1,"$50",IF(B1=1,"$40",IF
(C1=1,"$15",IF(D1=1,"$3")))) but I also want it to add
a1,b1,c1 and d1 if there is a 1 in each column.
 
I tried. Didn't work. Or i was just putting in the wrong
place. I want the money to add together just being
represented by a 1.
 
=IF(A1=1,"$50",IF(B1=1,"$40",IF(C1=1,"$15",IF(D1=1,"$3"))))&"-----"&SUMIF(A1
:D1,1)

returns $50-----4 if a 1 in all four cells (a1:d1)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top