Getting the 40% markup is easy, right? The rounding is the tricky pary. Use
this formula:
=A1+0.05-((A1*10) - INT(A1*10))/10
A1 is the cell with the number you want to round.
Getting the 40% markup is easy, right? The rounding is the tricky pary. Use
this formula:
=A1+0.05-((A1*10) - INT(A1*10))/10
A1 is the cell with the number you want to round.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks