Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: Help with counting discounts

Hi, I am new to numbers and cannot figure out how to calculate two discounts one after the other - X -Y%-Z%.


Here's what I would use in Excel:


X*(100%-Y%)*(100%-Z%)

MacBook Air (11-inch Mid 2012)

Posted on

Reply

Page content loaded

Mar 15, 2018 11:15 AM in response to Szmidt.Kasia In response to Szmidt.Kasia

Pretty much the same formula.

User uploaded file

Y2 and Z2 each contain 0.10, entered as "10%" (withot the quotes).

The percentage values may be entered directly, or may be entered as decimal hundredths ( "0.10" )and the cells formatted to display that as a percentage.


Regards,

Barry

Mar 15, 2018 11:15 AM

Reply Helpful
User profile for user: Szmidt.Kasia

Question: Help with counting discounts