Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel - Rounding after inputting a function
Name: Cyrcle Date: June 21, 2009 at 13:47:39 Pacific OS: Windows XP Subcategory: General
Comment:
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.
Summary: I am trying to assign a user defined VB function to excel cell. I wrote a s simple function called testy() in VB editor that returned a number. Function testy() As Single testy = 2.4 End Function ...
Summary: Excel already knows how to calculate using dates. From Excel Help - DAYS360: Quote Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some ac...
Summary: In an MS Excel document, I have a PDF link that I have no problem to open anywhere else. But on my computer, when I open that link, it opens Adobe and closes it right away (the document never opens......
0 
