Hello
I'm working through a salary spreadsheet and need to round up any 0.50 pence upwards and 0.49 pence downwords.
Any help would be much appreciated.
Thanks
J
Hello
I'm working through a salary spreadsheet and need to round up any 0.50 pence upwards and 0.49 pence downwords.
Any help would be much appreciated.
Thanks
J
if you want 0.50 to be 1 and 0.49 to be 0 then use =round(A2,0) assuming your value is in A2
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Works perfect, thanks for the speedy response.
Great! Glad that worked for you. If that takes care of your issue please don't forget to mark the post as solved using the thread tools dropdown at the top of the post - the mods like that if you haven't already done so.
AND, thank you for adding to my reputation - great way to start out a Friday.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks