View Single Post
  #2   Report Post  
dlw
 
Posts: n/a
Default

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.