Dec 21 2020 01:50 PM
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
Dec 21 2020 03:42 PM
Dec 22 2020 12:33 AM
Thanks that worked
What formula would I need for X*Y+0.35%=Z
Ie 15,332.92 * 0.19497503 + 0.35% = 2,999.99
Dec 22 2020 10:54 AM
@JMB17 Hay thanks for the reply, that gives me 30 instead of 3000?
Dec 22 2020 11:33 AM
Dec 22 2020 11:35 AM
Dec 22 2020 11:53 AM
@JMB17 i see and what if i want to take away a fee of 0.35%
Dec 22 2020 11:58 AM