反向百分比计算的Excel公式 [英] Excel formula for reverse percentage calculation
问题描述
我有一个我无法破解的计算.
I have a calculation which I am unable to crack.
假设我的成本价是 300.我想以 No Profit or No Loss 出售该商品.我的总佣金/费用将是 30%.所以这意味着我需要以 390 的价格出售该商品.但如果我做 390 - 30% = 273.
Lets say my Cost Price is 300. I want to sell the item at No Profit or No Loss. My total commission/expenses will be 30%. So it means i need to sell the item at 390. But if I do 390 - 30% = 273.
我怎样才能看到该项目,以便我减去 30% 给它.我的收入仍然是 300.
How can I see the item, so that if I minus 30% to it. My Revenue will still be 300.
推荐答案
你想要的公式是
=300/0.7
或
=300/(1-30%)
基本上是 300= x*(1-.30)
其中 (1-.30)
是在委托后想要保留的数量30%.求解 x 我们得到上面的公式.
basically it is 300= x*(1-.30)
where the (1-.30)
is the amount that wants to be kept after the commision of 30%. Solving for x we get the above formula.
这篇关于反向百分比计算的Excel公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!