Excel 2002...

[Carlo]

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

 

[David Biddulph]

=IF(OR(B7="Departure",B7="Arrival"),IF(OR(C7="Sedan",C7="Van"),20,IF(C7="Limo",22,IF(OR(C7="Bus",C7="Suv"),30,"Undefined"))),IF(OR(B7="Wedding",B7="Social"),IF(C7="Limo",10*N7,IF(C7="Suv",12*N7,"Undefined")),"Undefined"))

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

 

[Carlo]

DAVID THANK YOU VERY MUCH. I WILL TRY THIS STRING AND LET YOU KNOW, HOWEVER
I DO HAVE 1 QUESTION WHAT IS ,"Undefined" USED FOR AGAIN SIR THANK YOU VERY
VERY MUCH

 

[Carlo]

It worked like a dream, now I want to push the envelope a little further and
extend the string. David this may sound crazy but I am serious... If I send
you my spread sheet and if you look at the last tab within the spread sheet
you will see the run values for each job. I would be more than happy to pay
you for your efforts via PayPal if your interested. I dont know how you did
this but I am truly amazed.

PS the reason why I have to send you my spread sheet it would take me about
2 hours to tell you whats what, anyways Sir if your truly interested please
send me a email too (e-mail address removed) and place the above subject
line in the email, again thank you very much.