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 Round up w/in calculation
Name: Gmitts Date: May 27, 2009 at 07:37:56 Pacific OS: Windows XP Subcategory: Microsoft Office
Comment:
I have a simple calculation that divides a column # by 100, then multiplies that result by another cell. It looks like: =(100/N75)*B75
The problem is that the result of the first part (100/N75) may not be a whole number and I need that result to be rounded up before the 2nd part of the formula. Example, say N75 contains the number 18 (100/18 = 5.55. I would need that 5.55 to round up to 6 and then have the next calculation done - so 100/18 - 5.55, 6*B75. I hope the question makes sense - does anyone have an answer?
Summary: 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 wh...
Summary: Hi all. In excel 2003 I need a formula to do the following. Sorry for my description, I dont know how to put it better. I will have 2 numbers, A and B. number A needs to be rounded UP to match the nea...
Summary: Hello All, I wonder if anyone can help. We have over 90 different computers that have all suddenly started having the same problem with Excel 2003SP2. They have all been re-imaged over the past couple...
0 
