Forum Discussion
Formula for figuring prices including percentages
I've attached a spreadsheet that does this two different ways. It depends on the sequence of adding in those fees.
=Base*(1+EbayFee)*(1+PersFee) yields $12.42
=Base *(1+EbayFee+PersFee) yields $12.29
By the way, there are always other ways to write these formulas. For example
=Base+(Base*EbayFee)+(Base*PersFee) yields the same $12.29 as the formula shown above.
(Refer back to your high school math and the commutative properties of multiplication and addition)
I've attached a spreadsheet that does this two different ways. It depends on the sequence of adding in those fees.
=Base*(1+EbayFee)*(1+PersFee) yields $12.42
=Base *(1+EbayFee+PersFee) yields $12.29
By the way, there are always other ways to write these formulas. For example
=Base+(Base*EbayFee)+(Base*PersFee) yields the same $12.29 as the formula shown above.
(Refer back to your high school math and the commutative properties of multiplication and addition)
