| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Having problems to add additional info to this string....
Try this (untested):
=IF(Or(B7={"Departure", "Arrival"}),IF(Or(E7={"Sedan", "Van"}), 20,IF(E7="Limo", 22, IF(Or(E7={"Bus", "Suv"}), 30, "Undefined"))), If(Or(B7={"Wedding", "Social"}),IF(E7="Limo", 10*N7, IF(E7="Suv", 12*N7, "Undefined")), If(Or(B7={"Bar Run", "Night Out"}),If(E7="Sedan", 50, If(E7="Limo", 60, IF(Or(E7={"Suv", "Bus"}), 70, "Undefined"))), If(B7 = "Prom",IF(E7="Limo", 40, IF(Or(E7={"Suv", "Bus"}), 70, "Undefined")) , "Undefined")))) Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Additional info withthe POP up Calendar. | Excel Discussion (Misc queries) | |||
| How do i add additional info to a floppy disk? | Excel Discussion (Misc queries) | |||
| macro...additional info | Excel Discussion (Misc queries) | |||
| Add additional info to multiple fields | Excel Worksheet Functions | |||
| Repost with Additional Info | Excel Discussion (Misc queries) | |||
Threaded Mode
