Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if cell equals "a" then another cell would calculate percentage
I have a worksheet with a dropdown box of discount price codes and another
with list prices. I need another column that would automatically figure the discount when a certain price code is selected. For example: Column a column b column c List price price code new price 1000 a 900 (a=10%) Any and all help is greatly appreciated. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if cell equals "a" then another cell would calculate percentage
Given:
Discount Codes and values contained in worksheet "Discount", where A1:A3 have the codes and B1:B3 have the equivalent value. How about trying "=ROUND(A1*VLOOKUP(B1,Discount1!$A$1:$B$3,2,FALSE) ,2)" I would use this formula on your column C below. **I always like using the Round especially when multiplying percentages. "Brandy" wrote: I have a worksheet with a dropdown box of discount price codes and another with list prices. I need another column that would automatically figure the discount when a certain price code is selected. For example: Column a column b column c List price price code new price 1000 a 900 (a=10%) Any and all help is greatly appreciated. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
Sumif formula that uses "contains" rather than "equals" | Excel Discussion (Misc queries) | |||
Formula 'mis' calculate when reference cell contains a "0" | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |