Rounding Up A Cell Value To Next Highest Whole Number
May 4, 2006
I have a whole number value in cell F18. In cell F24 I want to enter a formula that allows me to divide the value in cell F18 by 4 and if the result is not a whole number, round it up to the next whole number.
I have a list of names in one column and in the next column I have a list of numbers. The names and numbers go together. In anohter cell I would like to extract the highest number and the name related to it. The list changes often.
I would like to be able to put a heading saying that "name" (in anohter cell) made the highest score and the name is entered into a cell automatically.
I have a sheet, along the top is the Months of the year, to the side I have a list of products. At the bottom of each month in a cell I want to display the name of the product that has sold the most for that moth, is this possible:
I can display the highest number i.e Highest item sold in January was 108, but I want it to write the product name.
Cells L5 - L65 have percentages. B5 - B65 Have the associates names. I want to write something in another cell that looks for the highest percentage and then prints the name as the highest.
I thought this was really easy and I swear that I did this before but I can't remember it at all. What I'm trying to do is take 2 user inputted dates and subtract them to get the total days. After that I divide it by 7 to get the total weeks. and ususally I will get a decimal. However I need to round this up to the next whole number.
I have a column of numbers that represent sales prices.
If the price ends in anything between .x0 - .x4 I want the replacement number to be .x4 and if anything between .x5 - .x9 I want the replacement number to be .x9.
For example, the sales price is 1.93. The "rounded" number should be 1.94.
I have an overtime spreadsheet where I calculate how mush I'm paying on vouchers, as they only come in lots to £5.00 I want to round the figure to the nearset £5.00, doesn't really matter if I overpay as it will even out next time, what's a basic forumula to work this out?
Suppose I have the following plan number (24) and I wan't to spread it across 12 columns, as evenly as possible but with respect to rounding. Easy enough.. Each column receives 2...
Or say the figure was 24.6 and i wanted to round to 2 places... Easy enough... Each column receives 2.05...
Or say the figure was 24.7 and i wanted to round to 2 places... Easy enough... Each column receives 2.05... But one would be 2.06!
How about the number is 1 and say, the rounding is 0.1? Ten of the columns would be .1 while two others (arbitrarily) would be 0.
I have a scenario where I calculate the size of a piece of process equipment, and then select the next highest size from a list of standard equipment that we supply.
I've managed to write an ugly brute-force solution to a relatively straightforward previous situation, but I'm reluctant to redo the entire exercise when I'm sure there's a more straightforward way of doing this.
An example of the problem:
We sell equipment in sizes 1, 3, 8, 12 and 25. I calculate that the piece of equipment theoretically needs to be size 19.6. I want a formula that will automatically generate the answer to this as 25. Similarly, if my formula shows a theoretical size of 12.01, I want the formula to state the actual size as 25.
My previous method of solving this was a series of nested ifs, searching for the rounded value of my formula output, then that value +1, then +2 upto a maximum of +5. This wasn't a pretty sight, but it worked for that situation.
Are there any other ways of solving this that are more elegant than mine?
Where: A23 = a date of installation I3 = TODAY() B23 = a number of years
It currently calculates correctly if the number of years correctly if it's older than 1 year. If under one year, it yeilds 0. I would like B23 to show 1 if the current formula yeilds 0.
I want it to yeild a 1 if the current calculation is 0.
My formula is not rounding properly. Cells I4, J4 and K4 all filter from the results of cell I3 divided by 3. (e.g. 10/3 = 3.333) I was able to remove the decimals in cells I1:K3, but the between formulas (I4:K4) keeps adding the decimal back, therefore this results in errors to my chart.
We are trying to find the correct formula to round number to the nearest even number. In the attached example, 0.105 should round to 0.10 since the zero to the left of the five is even. If the problem was 0.115 then the answer would be 0.12 since the one to the left of the zero is odd.
I have a few rows in an excel sheet and I want to highlight the highest number(s) in each row.
I've been playing around with conditional formatting, and using the formula: =$C23=MAX($C$23:$C$55) in the conditional formatting box and selecting a formatting type, I can automatically highlight the highest number in column C (row 23 to 55). However, this formula only seems to work when I'm selecting columns of data rather than rows. If I want to highlight the highest number in row 23, the formula I'm using is: =$C23=MAX($C$23:$M$23) Which I think should highlight the highest number From C23 to M23, but it doesn't - nothing happens.
in cell A1 i have the balance. i would like to record the balance every time it reaches a new high in cell B1. how would this be possible please using excel 2007
the problem i have is that if i have 14 in cell k6 and 1=10 in d6 the answer i get is 1.40 what i need the formular to do is always round it up to the highest number ie 2 not 1.4
I have a dilemma. What I want to do is: If I input a date in a cell I want the adjacent cell to take the next highest number from a list on another worksheet. My example attached
column a has dates & column d has values - what is formula to find highest number in values and return it's date (using =large(Dxx:Dxxx, 1) to find highest number
format: cell a1 Jones---56. In cell b1 I have another name i.e., Johnson---45. How can I subtract 45 from 56, take 60% of the difference and in cell c3 show the following; Johnson---6. All numbers are to rounded down to 0. The final result would look like this; a1 Jones----56, b1 Johnson----45, c1 Johnson----6. I have other cells with the same type of info in them. Example; a2 Smith----34, b2 Jones----78, c3 would show Smith----26.(rounded down) I always want to subtract the lower number from the highest and take 60% of the difference.
I am attempting to pull the Highest number out of a row of cells. Then grab the info 23 lines below. What I have is a spreadsheet that pulls from other spreadsheets and tracks all of my sales for the year. This is divided up into tabs for each day of the week. I am a formula to find the highest sales for Tuesdays {LARGE(Tuesday!B8:BB8,1)} then in the cell below it I need it to show the date that days sales happened on. That date is listed 23 lines lower. I have tried using {HLOOKUP((MAX(Tuesday!B8:B88)),Tuesday!B8:B88,23)}. This kinda works. It pulls from the 23rd line but only from the first column. Not the column that has the highest sales. I have searched for a solution but I must not be typing in my question correctly.