Complex IF Statement
This worked!!!
THANK YOU!!!
"Brad" wrote:
Assuming the data start in row 2 (not row 5) this is one alternative that
will work.
=IF(A2<=400,(E2+F2)*5,IF(A1<=400,(400-A1)*5+(A2-400)*8,(E2+F2)*8))+G2*2
--
Wag more, bark less
"Jonni" wrote:
Something still doesn't work, or I am having a braindead moment,
My cummulative column is A4, so initially A4 = E4 + F4
A5 = (A4 + E5 + F5) and so on.
My total column now multiplies A5*5. I need it to mutliply (E5 + F5)*5
unless one of the values makes the total greater than 400.
"Brad" wrote:
=Min(400,a4)*5+max(0,a4-400)*8
"Jonni" wrote:
I am trying to write a formula charging the first 400 tickets $5 each. But as
soon as the 401st is sold, I need it to be $8.
Tickets are not being sold one at a time. This is for a family event, so it
could be 5 tickets at a time.
The current fomulas I have
=IF(A4<=400,(E4+F4)*5+G4*2,(E4+F4)*8+G4*2)
will charge $8 a ticket, if a family of 4 are tickets 398, 399, 400, and
401. I need the first three to be $5 each, and one ticket to be $8.
Where A4 is a cummulative column (A5's formula is =SUM(A4+E5+F5))
|