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

"LowRider" wrote:
so in E I would want the Cell to show 45.954 which
reflects the discount.

Ostensibly, you want:

=D2*(1-8%)


----- original message -----

"LowRider" wrote:
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