Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Formula to copy a rounded number

Copper Contributor

My spreadsheet adds up time to get a total number of hours. I'm using ROUNDUP() to convert numbers like 7.5 to 8. When I try to to an additional calculation to multiply that rounded number by a rate, the calculation keeps using the original (7.5) number. 


I've tried using value() and text() with no success. Is there any other way of using the rounded number in my subsequent calculations?  





2 Replies


You could store the formula as a named item and then reference that name in formulas where needed.



Another option would be using the LET function.



We cannot tell anything from a screenshot alone.  At the very least, you should also post your formulas.  Even better, attach the Excel file, not a screenshot.


Presumably, you simply multiplied by the wrong cell.  To demonstrate:




The correct reference is C6, where you rounded up, not C5.


Alternatively, you could write B7*ROUNDUP(C5,0).