=IF(OR(B7="Departure",B7="Arrival"),IF(OR(C7="Seda n",C7="Van"),20,IF(C7="Limo",22,IF(OR(C7="Bus",C7= "Suv"),30,"Undefined"))),IF(OR(B7="Wedding",B7="So cial"),IF(C7="Limo",10*N7,IF(C7="Suv",12*N7,"Undef ined")),"Undefined"))

I've assumed that your vehicle type is in C7; if not, change the cell
reference as appropriate.
--
David Biddulph

"Carlo" wrote in message
...
Hello I have created an extensive work book, now I am trying to add
function
to it. Is this even possible or do I need to purchase a data base program.

If B7="Departure" and or "Arrival" using a Sedan and or Van the value is
$20.00, however if I am using a Limo the value is $22.00 and if I am using
a
Bus or Suv the value is $30.00

If B7="Wedding" and or "Social" using a Limo, it would be $10 x number of
hours in N7 or a Suv it would be $12 x number of hours in N7