Very straight forward and Clear. Could you please show the formula for getting a total based on subtracting a percentage? For example - If Column B has an item price, and I want Column D to show the total subtracting the 3% credit card fee. How would I do that? Would love if you can also show us how do that with variable amounts, based on the info in Column C, but that is far more complicated, I suspect. For example - If Column C says the payment method was Credit Card, then it would subtract the 3% fee in Column D. If Column C says the payment method was Cash, then it would show the full amount in Column D. If Column C says the payment method was ACH, then it would subtract just a 1% fee in Column D.
Ive watched like 6 videos trying to figure this out, was trying to find the percentage of 5 rows in google sheets. Ended up using this formula if anyone else needs it. =(B2+C2+D2+E2+F2)/100
If you were trying to calculate the total winrate in a scenario like that something like this would work: =SUM(range)/COUNT(range). Range is just going to be the range of cells that have the 1 or 0 in them. The COUNT function will count the total number of cells that have a number in them and the SUM function will sum all of the wins (1's) together. So if you have 10 cells with 4 wins (1's) and 6 losses (0's) the formula would be calculating 4/10 = .4 or 40%
I'm working out my ROCE in my property deal analyser I've got £2,700 profit so it +100% how can I get the +100%?? Let just say it should be 113% but it showing 57.92%
❤ this I want to ask how do I get the percentage calculated of 52% with the subtotal of $3.69 to the total discount in a coupon spreadsheet using google Sheets? Please need help with these formulas.
If something has 20% included already, you could take that number and multiply it by ".834" and that would give you approximately the original amount. If you want the exact amount you would multiply it by "0.833333333333333"
![กี่หมื่นฟ้า | Your Sky Series EP.1 [1/4]](http://i.ytimg.com/vi/vLGjxFL6U_I/mqdefault.jpg)
Very straight forward and Clear. Could you please show the formula for getting a total based on subtracting a percentage? For example - If Column B has an item price, and I want Column D to show the total subtracting the 3% credit card fee. How would I do that? Would love if you can also show us how do that with variable amounts, based on the info in Column C, but that is far more complicated, I suspect. For example - If Column C says the payment method was Credit Card, then it would subtract the 3% fee in Column D. If Column C says the payment method was Cash, then it would show the full amount in Column D. If Column C says the payment method was ACH, then it would subtract just a 1% fee in Column D.
How do you do a formula for a pricing sheet where I can put one price and have 5% , 10 %, 15% discounts in different cells ?
Ive watched like 6 videos trying to figure this out, was trying to find the percentage of 5 rows in google sheets. Ended up using this formula if anyone else needs it. =(B2+C2+D2+E2+F2)/100
what about if you had a row of cells that had a 1 or 0 in them and you wanted to calculate a winrate from it? 1 win, 0 loss. How would I do that?
If you were trying to calculate the total winrate in a scenario like that something like this would work: =SUM(range)/COUNT(range). Range is just going to be the range of cells that have the 1 or 0 in them. The COUNT function will count the total number of cells that have a number in them and the SUM function will sum all of the wins (1's) together. So if you have 10 cells with 4 wins (1's) and 6 losses (0's) the formula would be calculating 4/10 = .4 or 40%
I'm working out my ROCE in my property deal analyser I've got £2,700 profit so it +100% how can I get the +100%??
Let just say it should be 113% but it showing 57.92%
How do you do it with only one column?
❤ this I want to ask how do I get the percentage calculated of 52% with the subtotal of $3.69 to the total discount in a coupon spreadsheet using google Sheets? Please need help with these formulas.
Hello. I didn't quite follow that. What are you trying to calculate?
if I have a total that has 20% included it already but I what to minus that to find the original amount - how do I do it?
If something has 20% included already, you could take that number and multiply it by ".834" and that would give you approximately the original amount. If you want the exact amount you would multiply it by "0.833333333333333"