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)
Thank you! The problem is that many years ago (ahem, over 40!) Math wasn't my strong suit, and I don't think my understanding has gotten much better. But I appreciate the examples ... I can work with those and figure it out. I appreciate you taking the time to reply!