value- 1000
rate- 5%
value+rate-1050
addition -50
value-rate-952.38
reduction- 47.62
how to calculate 952.38.and how to put in excel.
Sivaramakumar
(GM-ACCOUNTS)
(142 Points)
Replied 11 April 2016
1000*5/105 WILL GIVE YOU 47.62
1000*100/105 WILL GIVE YOU 952.38
1/20 TH ON COST IS EQUAL TO 1/21 ON SALES