Forum Discussion
subtracting decimals percentages in excel
Hi,
This is the formula I’m trying to do in excel Buy amount – Fee ÷ Desired Price = amount.
Ie 20000 – 0.35% ÷ 16500 = 1.2078
But it will not – 0.35%. What formula do I need to use? The formula im using is =B20-C20/D20
8 Replies
- Excel follows the standard order of operations and divides before subtracting. So, 0.35%/16500 is a very small decimal.
Also, I'm guessing the 0.35% fee is based on the buy amount?
Try this:
=(B20-B20*C20)/D20
