Percentage Help

  • Thread starter Thread starter LowRider
  • Start date Start date
L

LowRider

Hi All,

I am trying to figure out how to get a percentage to show up in certain cells.

THis is what I have:

C D E F
G
List Price Retail Price Wholesale Sponsor1 Sponsor2
20.00 49.95 =8%*D2 =7%*D2 =6%*D2

SHOWS AS 4.00
WANT 45.95

Ok the formula =8%*D2 shows the discount amount of 3.996 but what I want to
do is show the actual cost. So if I subtract 8% from 49.95 the discount
would be 3.996 so in E I would want the Cell to show 45.954 which reflects
the discount. Same goes for F and G.

Your help would be greatly appreciated.

Thanks much in advance
 
Back
Top