Excel - Rounding after inputting a function

June 21, 2009 at 13:47:39
Specs: Windows XP
I own a cleaning business and am working on a generalized payment sheet for myself. However, I can't seem to figure out how to round up after I've already inputted a function.

I've got it set up where if I input a number of units I clean, it automatically calculates that 65% of them will need cleaned the next week. However, this comes up as a decimal. You can't clean 13.65 condos. I can hide the decimal places, but I want it to actually round the number in the same cell, if possible.

Below is a picture of the excel file if you don't quite get what I'm asking.


See More: Excel - Rounding after inputting a function

Report •

June 21, 2009 at 13:51:25
Nevermind, I seemed to have figured it out. I was using the wrong syntax for the round function the entire time.

Report •
Related Solutions

Ask Question