In cell c6 is €500.00, In cell d6 after using lookup to calculate discount is 20%.?

0 ⤊

In cell c6 is €500.00, In cell d6 after using lookup to calculate discount is 20%.?

What I need to do now is calculate new price in cell e6. Do not know the formula. Can you help?

2007-11-23 01:36:38 · 2 answers · asked by Anonymous in Business & Finance ➔ Other - Business & Finance

2 answers

I'm not really clear about your question. Are you asking about Excel? If cell C6 is €500.00, and you want D6 to be the discount of 20%, the formula for D6 is =0.2*C6. If you want E6 to be the amount after the discount, then the formula for E6 is =C6-D6. If this is not what you meant, send me an email and I'll see if I can help.

2007-11-24 22:57:09 · answer #1 · answered by Sandy 7 · 0⤊ 0⤋

2017-01-22 06:12:54 · answer #2 · answered by Judy 4 · 0⤊ 0⤋