Exel % discount help

[Gonazalo]

hi i would like to ask for your help ,


i meed to created a price list but is a bit complicit as im not use to excel
im planning to buy stuff and they are different grade of the same product
example : grade A = 100% (1000) Grade B= 85%(850) grade C 65%(650) and so on

many thanks

[jeffreybrown]

Sounds to me like a Lookup table would work if I understand your question correctly.

http://www.contextures.com/xlFunctions02.html

[Gonazalo]

Many thanks
all done

[jeffreybrown]

Happy it worked out for you. You're welcome.