Forum Discussion
Formula to copy a rounded number
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,...
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).