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,...
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.