On Apr 1, 4:07 pm, Greg Wilson
wrote:
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

Hi Greg

That is alot of IF statements, would a look up table be better. I
think you may have maxed out the number of nested IF statements you
can make (Office 2003) but unsure what version of Excel that you are
running


Dougal Everingham
Senior Solutions Consultant

CONTROL PLAN REPORT ANALYSE IMPROVE

Australia
Level 10, 390 St Kilda Road, Melbourne VIC 3004


www.satorigroup.com.au

The Satori Group is an international consulting company specialising
in designing and implementing business improvement solutions