MrExcel.com - Your One Stop for Excel Tips & Solutions

roundup

Posted by Andonny on November 20, 2001 3:42 PM

Hi,
I am trying to roundup to the nearest 50 cents.

Thanks for your help
Andonny

Posted by Mark W. on November 20, 2001 3:46 PM

=CEILING(A1,0.5)