Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get Excel to automatically chose one of two answers?
I am trying to design an automobile purchase order form that uses option
codes and its corresponding prices. When I enter one option code on one cell/row (i.e. LCB4 for Leather Upholstery), the cell next to it will automatically kick out the correct price of $1450. However, another option code (i.e. ZPP for an automobile Premium Package) at the price of $2900 includes Leather Upholstery. If ordered, I need to enter ZPP on another cell/row that will generate the priceof $2900 next to ZPP; however, I do not know how to get Excel to automatically recognize the ZPP code and change my Leather Price of $1450 to $0 since it is included in the Premium Package. Can anyone assist? Thanks again. -- Erwin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Changing Numbers Automatically | Excel Discussion (Misc queries) | |||
How do i update hyperlink in excel spread sheet automatically. | Excel Discussion (Misc queries) | |||
Need Answers to Urgent Questions on Excel! Hurry, oh, please hurry! | Excel Discussion (Misc queries) | |||
Can you automatically insert next sequential number in an excel fo | Excel Discussion (Misc queries) |