=IF(E14="","",ROUNDUP(E14*M5/0.5,0)*0.5)
I am using this formula which works great except on thing.
I do want rounding up by .5 except where the roundup is equal to less than 1 as I need 1 to be the min.
ie result .45 would round to 1, result .1.45 would round to 1.5
Maybe this?
=IF(E14="","",if(E14<1,1,ROUNDUP(E14*M5/0.5,0)*0.5))
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
Hi,
Perhaps
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank-you for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks