Thread: Excel Help
View Single Post
  #4  
Old 11th September 2007, 01:20 PM
stugots stugots is offline
Banned
  
Join Date: Jan 1970
Posts: 868
Default
for closest 0.50c

=CEILING(A1*0.03,0.5)

or closest $1.00

=CEILING(A1*0.03,1)
Reply With Quote