nearest

Hi all, I am trying to work out a formula that will round a number to the nearest 5 or 9. For example: 656 goes to 655 681 goes to 679 684 goes to 685 723 goes to 725 780 goes to 779 809 stays at 809 837 goes to 839 970 goes to 969 etc. I have this formula currently: <style...

Hello, newbie here - nice to be a part of the forum. Could someone please help? I am trying to calculate two fields together (to get a price) and then wish to add on 20% to that and round it to the nearest fifty, for instance £837.60 to £850.00, is this possible please? I seem to remember...

So I have a formula written that works for what I am trying to do. I have it rounding to the nearest 500, either up or down, but I need it to round down at the 250 mark, not up. So what I am trying to do is.... 5250 goes to 5000 6380 goes to 6500 7750 goes to 7500 any help is appreciated.

Hi everyone I have to roundup an userform decimal places to the nearest 0.25 or 0.5 or 0.75. I use the following formula but it is only to set the decimal place to two digits but cannot round up. Please can anyone help? tBox3 = Format(Round(Val(WordCount) / Range("$C$21") * 1.3, 2), "0" &...

I hoping this is simple and makes sense so here goes! I am looking for a formula to round a number to the nearest .025. For example Cell A1 contains .0280 and I need to round it the to the nearest .025, in this case .030 as my results have to be in .025 increments.

Hi, I have a cell that someone will be manually typing a number into. After they enter the number, I need that number to be rounded to the nearest thousand. Since this cell is one that will be manually typed into, this automatic rounding of whatever number they put into the cell has to be done...

All, I must be doing something way wrong. I am trying to have something in excel that is =Now(Hour(1)) so I am wanting to round down to the nearest hour. I am sure this is beyond simple but I can not get it. any help would be great. thanks

Hi I have a discount column that i would like to round the values to the nearest 10th or to 5th. So a result of 24.9 = 25% 21.2 = 20% 57.1 = 55% =MROUND(1-('SALES TABLE'[NET RETAIL]/'SALES TABLE'[RETAIL]),.1) ​Thanks

hello all, I have tried to tweak some of these formulas that are similar to what i am searching for but with no luck. I have values in A1:A19 with a reference in B1. I would like conditionally format the three rows A:D that hold the closest values, with higher or lower not being relevant...

I would like to search 5 unique product sheets (one at a time) through a drop down selection interface on a separate sheet. The search is based on 4 input criteria (length, width, height and mass) and match the closest record containing the next largest dimensions across these 4 individual...

I have a problem which I have been trying to solve but I need help. Thanks in advance for any answers. I have time series data, much of which is in complete. So for example there might be 4 years missing in the series. What I'd like is a formula which finds the nearest non-blank value both...

Example I have 2 sheets in a work book "ListA" with a table and "Main" Sheet "ListA" A B C -------------- red 3 10 blue 2 11 red 4 12 red 1 8 blue 3 7 In my sheet "Main" I will like to find the nearest value in that table from "ListA" column "C", but also...

Windows 7 Excel 2010 I would like to compare a list of dates (attributed to a single item, in "sheet1") against a list of dates (attributed to the same item, in "sheet2") and return which of the dates in "sheet1" are within X months (will be using 18 and 60 months) of any of the dates in...

Hi I have the following data: <table border="0" cellpadding="0" cellspacing="0" width="745"><colgroup><col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="width:48pt" span="6" width="64"> <col...