I need to round, up or down, dollar figures to the nearest .x9 cents. Examples:
$4.32 = $4.29
$5.55 = $5.59
$3.07 = $3.09
$5.00 = $4.99
Thanks for any help.
I need to round, up or down, dollar figures to the nearest .x9 cents. Examples:
$4.32 = $4.29
$5.55 = $5.59
$3.07 = $3.09
$5.00 = $4.99
Thanks for any help.
Last edited by oldchippy; 10-23-2008 at 04:03 PM.
Hi,
Does this work for you?
=IF(MOD(A1,1)<=0.99,ROUND(A1,1)-0.01,ROUND(A1,0)-0.01)
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thats perfect, thanks.
Glad it helped - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks