I need a forumula that will round all numbers down to fifty cents for example:
$10.93 would be 11$
$10.63 would be 10.50
$10.20 would be 10$
I need a forumula that will round all numbers down to fifty cents for example:
$10.93 would be 11$
$10.63 would be 10.50
$10.20 would be 10$
Your first example rounds up?
Sorry first example would round to 10.50
Going by your example;
Formula:Please Login or Register to view this content.
And copy down.
Then;
Formula:Please Login or Register to view this content.
And copy down.
What is the second formula for?
Try
=ROUND(A1*2,0)/2
I modified it to give $10.50 for case 1.
Great, Thanks so much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks