round ()

Is it possible in the same formula to Rank and Round together? I have the following formula but it is returning #N/A. I assume this is because the whole reference is not rounded which leads me to believe this is not possible to do in one step. However, I thought someone may know of a workaround...

I am attempting to write a formula to assist with quality control during a payroll process (less manual manipulation). I would like a formula that pays an employee a specific amount (let's say $5,000 + 3%) until a specific date (let's say 11/14/2018). Once that date has past, I would like the...

I found a way to add "Round()" to a range of cells (https://www.mrexcel.com/forum/excel-questions/618276-add-round-function-all-cells.html). Then I discovered an error in the underlying formulas. I've now decided I need to learn VBA well enough to not have to ask for assistance. But until then...

Hi Team, I'm struggling with rounding off scenarios in Excel. Can you help me with the below problem statement. Data- <tbody> Customer Location Sales Qty (MT) Possible Truck Type Truck Type Truck Type(Tolerance) X 20.3 15,20 Y 18.3 16,20 Z 9.9 10,15,20 </tbody> Output...

Firts let me say thank you for any help you can lend, I am not an Excel expert by any means. Just a simple noob that can add a few number together or simple math calculations. I am trying to use a formula to calculate Weight Watcher Points Plus for my Wifes website, she is getting ready to go...

Hi, can anyone help me round down to the nearest 10,000 So, if it's 84,000, it'll round to 80,000 If It's 86,000, it'll round to 80,000 etc... I found this online, but it doesn't work properly past 100,000..it just rounds down to the nearest 100,000 when it gets past 100,000...

[SOLVED: workaround found, see bottom] (Before you reply, I do understand that most decimal numbers can not be expressed exactly in binary format, even simple numbers such as .3. I'm trying to limit the number of digits after the decimal that are shown.) I'm trying to cleanup the data table...

Hi, I have a column with formulas =round(A2/B2,2) and there are some output in the columns like 485.00, 853.00 When I copy those values and paste as values in any other cell or sheet it just displays "485", "853". But I want it to display complete 485.00, 853.00 Is it possible?