Reply
Wed 11 May, 2016 02:06 pm
In Microsoft Excel, what would be the formula for subtracting 20% from an amount and then subtracting an additional 25,000.
For example, 135,267 -20%=108,213.6-25,000=83,213.6.
135,267 is in cell B2.
A2=B2*0.8-25000
Write your initial figure in B2 and the formula in A2.
@timur,
Ah! Thank you very much, timur.