Thread: Excel Help
View Single Post
  #3  
Old 10th September 2007, 11:59 PM
SeeDee SeeDee is offline
Member
  
Join Date: Apr 2005
Posts: 39
Default And, if you want to round it to nearest 50c
=round(A1*3/100/5,1)*5

I know it should be A1*3/500, but the above is easier to follow.
Reply With Quote