4,374.00
Actual Desired
4% 174.96 175.00
5% 218.70 219.00
6% 262.44 262.00
7% 306.18 306.00
Pl.look up the above datas.I am calculating the various percentage from an amount i.e.4374.00 and the actual result is coming say,174.96,218.70,etc.But,I want the desired result say,175.00,219.00 etc.The condition is,if the actual calculation appear decimal between 0 to 49,then,convert into last one ie.174.00 and more than 49 then ,convert into next 1 i.e.175.00.
In my example,pl.review the result of 4%,5%,6% and 7%.4% is 174.96 but i want 175.00,7% is 306.18 but I want 306.00.Is it is possible from an Excel formula?
Regards
Bookmarks