| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex IF Statement
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)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex IF THEN statement | Excel Worksheet Functions | |||
| Complex If/And Statement | Excel Worksheet Functions | |||
| Complex IF STATEMENT | Excel Discussion (Misc queries) | |||
| Help with complex If statement | Excel Worksheet Functions | |||
| complex IF(OR(...AND())) statement | Excel Discussion (Misc queries) | |||
Threaded Mode
