Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having problems to add additional info to this string.... | Excel Worksheet Functions | |||
Additional info withthe POP up Calendar. | Excel Discussion (Misc queries) | |||
macro...additional info | Excel Discussion (Misc queries) | |||
Add additional info to multiple fields | Excel Worksheet Functions | |||
Repost with Additional Info | Excel Discussion (Misc queries) |