# rounds

1. ### Help with Rounding up a formula to a whole number

=IF(MOD((J29*1.1),12)>=9,CEILING((J29*1.1),12),(J29*1.1)) This current formula I am using is not working the way I want it to. Here is what I am trying to do: I want the user to enter a number in cell J29. Cell B29 then takes that number and multiplies it by 10%. The result of that number...
2. ### Round up to intervals after cell reaches certain number

I need help writing a formula that will increase a cell by a certain multiplier if and when another cell gets beyond a certain number(s). For example: Cell G5 has a multiplier of 25. Cell B5 is where I input my number anywhere from 0-1000. Cell C5 is the output of my multiples of 25 IF the...
3. ### average of last 3 and last 10 data sets when data is non contiguous

hi, bit of background. I'm trying to create a statistics excel sheet for my appallingly bad golf short game. I'm recording the distance to the flag for each putt using my stride length as the standard unit of measurement. anyway I have formula In place that calculate the running total of all...
4. ### SUM Cells Using INDIRECT(ADDRESS()) on Same Sheet?

Hello all! I've got a small spreadsheet to keep track of the decks I have for a trading card game, and how many wins they have when played against my other decks. I play three rounds each against each combination of decks. The sheet is laid out such that both the first row and first column...
5. ### round number in excel

I want to round the number for the decimal part 0.6, e.g if the calculated is 4.6 or 7.79 it rounds up, otherwise if the calculated is 2.5 or 9.43 it would round down. Can anyone help me?

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...