two percentage discounts in one cell

[Roni]

i'm trying to discount a number twice in one formula.

$320,400-50% and then -57% from that.

HOW do I do this????

 

[Anne Troy]

Which number are you trying to discount?
$320
400??

Could you give a little more information?

If there's a value in A1, this formula should discount it twice:

=(a1*.5)*.57

 

[Mark W.]

=320400*0.5*0.57

 

[Anne Troy]

Duh.

Hi Mark!

 

[Roni]

trying to discount $330,400 which is a NUMBER in cell G8. I need to take that number and subtract a percentage (dynamic # in Cell B8) and then subtract another percentage (dynamic # in cell H8) from that.

 

[Mark W.]

trying to discount $330,400 which is a NUMBER in cell G8. I need to take that number and subtract a percentage (dynamic # in Cell B8) and then subtract another percentage (dynamic # in cell H8) from that.

=G8*B8*H8

Note: It would be quite helpful if we knew the desired result of this calculation to be sure that we're interpeting your question correctly.

 

[Roni]

that's what I thought and tried, but that keeps coming out to: 89,664 when it should come out to 70,536.

 

[Anne Troy]

Is the number in cell G8 REALLY an exact percentage? Or are you just viewing it that way? Is it being rounded by your view/format on that cell?

I don't get either of those number.

I get 91314

 

[Roni]

the number in G8 is a number (currency $320,400). From that number I need to subtract a percentage (which will change) that is formatted (I believe) as a percentage in cell H8, and then from that, I need to subtract another percentage (which will change) in cell B8.

 

[Mark W.]

that's what I thought and tried, but that keeps coming out to: 89,664 when it should come out to 70,536.

Yeah, but what's in B8 and H8 And, keep in mind we need to know what's stored there (visible on the Formula Bar) -- not what's displayed in these cells.

Case in point -- I can get 89644 if B8 contains 0.49 and H8 contains 0.565227808673502 which when formated as 0% appears as 50% and 57%.