Get instant live Excel expert help to learn how to round a number in Excel

I use a Google Sheet to keep track of prospective investors. The first tab functions as a master tab. Some of the columns I use to categorize the prospects. For example, if they are a candidate to lead for the next round, in the column, I would put a y for Yes. Then, I would like to have a separate tab that shows only those investors that I have flagged as possible lead investors.

Is there a way to do excel round up and down to a set group of quantities?

Hello, I have times in cells and I need to do some disproportionate rounding. I need to round the minutes as follows: 12:51 to 13:05 rounds to nearest qtr interval of 13:00 13:06 to 13:20 rounds to nearest qtr interval of 13:15 12:21 to 13:35 rounds to nearest qtr interval of 13:30 12:36 to 13:50 rounds to nearest qtr interval of 13:45 13:51 to 14:05 rounds to nearest qtr interval of 14:00 And so on. I can't get my head around this at all!

The demand curve for tickets at an amusement park is: Q=D(p)=1900−45p Q=D(p)=1900-45p , p > 0 The marginal cost of serving a customer is $14. Using calculus and formulas (but no tables or spreadsheets) to find a solution, what is the profit-maximizing price? Round the equilibrium quantity DOWN to its integer part and round the equilibrium price to the nearest cent.

I need a formula to convert entries in rows to columns. The first set of data is in the following cells; F3 to I3 including mround excel function: mround(F3,:"0:30") to round the data G3 to J3 F4 to K3 G4 to N3 including the formula mround(G4,"0:15") to round the data The trouble is there isn't always only two rows of data. Sometimes there is 3 rows as the employee has taken 2 breaks. If this occurs these extra entries need to be moved to L3 and M3. There are also rows that have no time data as this is a payroll line. The empty rows can be 1 or 2 rows of empty data. The formula will need to be copied down 14000 lines of data.

Was on earlier expert fixed problem but it doesn't work now . I want the latest 5 scores > 0 out of the last 10 weeks of values listed , the select the highest 3 scores out of the five and avg. them to determine the points required for the next round of golf.

Trying to create a macro that will count the number of deliveries per PO by row, divide it by total wt. evenly. If number is not even, then round uneven number, multiply by 2, subtract total from total wt. and use NEW total wt. to distribute to remaining boxes. Variable would be the number of boxes and deliveries and wt.

There was a formula tutorial on my pc have gone to access it today and it disappeared from excel home page. Got it back but file will not open. Also take a tour round excel has gone

The formula below is coming back with an error; "You've entered too few arguments for this function" I dont know why? Can anyone help? =concatenate(round(($B$1/D5)*C5), " Grams or ",round((($B$1/D5)*C5)*0.0352,2)," ounces of ", A5, " weighed on a food scale")

I'm using the CEILING formula to calculate the duration between start/end times (round up to each 6 minute increments), in the form of a decimal number. Example, 6:00 to 6:30 is 0.5 hour (=CEILING ((B2-A2)*24, 6/60). For some reason, each 6th minute mark is counted UP, so instead of getting "0.5" I'm getting "0.6"