Having problems to add additional info to this string....
 

Would you mind helping me two break this string up in 2 and 3 then.

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

"Carlo" wrote:

I have been banging my head against the table trying to ADD to this string,
however I have had no luck. Can someone help me, if all possible please.

CURRENT STRING

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

Additional Info to add:
If B7 = Bar Run or Night Out and if using a Sedan = $50, if a Limo = $60 if
using a Suv or Bus = $70

Additional Info to add:
If B7 = Prom and if using a Limo = $40, if using Suv or Bus = $70