 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008Excel 2002...
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 =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. -- David Biddulph > Hello I have created an extensive work book, now I am trying to add > function [quoted text clipped - 7 lines] > 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 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 > =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")) > [quoted text clipped - 14 lines] > > 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 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 carlogallo@print-broker.com and place the above subject line in the email, again thank you very much. > =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")) > [quoted text clipped - 14 lines] > > 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.