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
|