Hi,
I have a formula in a cell which contains 2 parts. The first part is what i need to be rounded up. This formula is in cell K8. I need to answer to be 0 but as the first part of the formula is not rounded up i get a negative number. K8 is formatted as number with no decimal places.
How I'd like it to work is for cell K8 to do its calculation and equal to 8. The user will input numbers into cells F6:J7. If the user input 1 into F7 then cell K8 should reflect 7 (as in there are 7 more available.) If the user then inputs 7 into cell G7 then cell K8 must reflect 0. But it does not. It reflects -1.
If the first part of the formula in cell K8 was rounded up then I think this problem would be fixed but I can't figure out how to do it.
Please help.
I am using version 2404 of Excel on PC, Microsoft Office 365
Thanks.
Liam
Hello,
You can use the ROUND or ROUNDUP functions, more about those functions in this blog article How to round numbers in Excel.
Check attached file for an example.
Br,
Anders
Hi,
I have tried the Roundup within the formula but it doesn't seem to work. I get a notification saying I've entered too few arguments for this function.
This is what I tried: ((((ROUNDUP(C5*(D5/100)); 0) - SUM(F6:J7)))
Please advise.
Thanks
Hi Liam,
If you are trying to round to 0 decimal places, your 0 is in the wrong place, use this
= ROUNDUP(C5*(D5/100),0) - SUM(F6:J7)
Regards
Phil
Hi Phil,
That worked!
Thank you so much!
Kind regards,
Liam
No worries.
Phil
