Prev: Missing alphanumeric number in the sequence
Next: Merging Columns
From: LowRider on 8 Mar 2010 02:23
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
From: Joe User on 8 Mar 2010 02:36
"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
 | 
Pages: 1
Prev: Missing alphanumeric number in the sequence
Next: Merging Columns