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?  

 

Wm

 

 

2 Replies

@MortonVisuals 

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

Patrick2788_0-1681496456519.png

 

Another option would be using the LET function.

@MortonVisuals 

 

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:

 

JoeUser_0-1681500907095.png

 

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

 

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