Creating a formula

G

Guest

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
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Creating Excel Formula 4
Excel functions 0
Need help 2
Percentage Help 1
fomula required 6
I have a pairs of numbers 1
creating formula in excel 1
remove blanks using formula 5

Top