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????

 

[RalphA]

I thing the operation is supposed to be:

=G8*(1-B8)*(H8) = 330400*(1-.5)*(1-.57) = 71036.

Or, in the poster's words,

330400 -(330400*.5) = 165200
165200*.57 = 94164
165200 - 94164 = 71036

 

[Roni]

turns out that formula worked, except I was supposed to SUBTRACT the first percentage and work off that result. As I was using 50% as an example, it worked for both sides, but I need the percetage subtracted from the whole number and to work on just that percentage. (i.e. 320,400 - 25% = 80,100, then minus the next percentage, say 15% = 68,085)

 

[RalphA]

Huh?! Since when does 320,400 - 25% = 80,100? The only way to get 80,100, starting out with 320,400 is to subtract 75%, so:
320,400-75% of 320,400 = 80,100. This is usually done so:
320,400*0.25 = 80,100 Could it be that, in your haste, you pressed the minus sign, -, instead of the multiplication sign, * ?