MrExcel Publishing
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)