Formula meaning =C16-C16/(1+D16)

[mrmangesh]

Experts want to know meaning of the formula

=C16-C16/(1+D16).......

(Cells contain C16=12, D16=20%)

Ans. is 2

What is this formula

 

[mole999]

You might need to read up on PEDMAS / BODMAS

to solve maths you do what ever is insided the brackets first, so 1+D16 then Exponentials, then Division (C16 divided by the previous workings), then Multiplication, then Addition then SUbtraction C16 Minus the previous calculation part

 

[jimrward]

Looks like a tax calculation to show the amount of tax on an item

Sale value = 12
Tax = 20%
Item cost before tax C16/(1+20%) = 10
So subtracting the two 12 - 10 = 2 the amount of tax or vat

 

[mrmangesh]

@jimrward

Correct and thank you....