I have a list of values that I need to round down to the nearest 8.
For example, here are some values:
$742.00
$717.80
$3,958.80
I would need a formula that would produce:
$738.00
$708.00
$3958.00
Any suggestions? I'm stuck on this one! Thanks so much.
If your value is in A2 then try this formula to round as required
=FLOOR(A2+2,10)-2
Audere est facere
Hi and welcome to the forum
This is a bit big, but I think it gives you what you want...
=IF(RIGHT(ROUNDDOWN(A1,0),1)=8,ROUNDDOWN(A1,0),ROUNDUP(A1,-1)-12)
edit: well la te da DDL lol
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks