| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a formula
I am using excel 97
If A1 is Retail price A2 is Discount Code A=50%,B=55%,C=60% What formula can I use in A3 to reach cost -- Dave1125 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a formula
Dunno the relationship between Retail Price and Discount Code, but maybe
this formula will help..... =IF(A2="A",A1*0.5,IF(A2="B",A1*0.55,IF(A2="C",A1*0 .6,""))) Vaya con Dios, Chuck, CABGx3 "Dave" wrote in message ... I am using excel 97 If A1 is Retail price A2 is Discount Code A=50%,B=55%,C=60% What formula can I use in A3 to reach cost -- Dave1125 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating charts from formula results | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
| Creating a specific formula | New Users to Excel | |||
Linear Mode
