Hi again guys! Thanks to you I'm optimizing a lot my worksheet! I have another question to ask you.
AQ2: =(AO2-AP2). That ecuation gives me a result that I need to round with the next criteria:
If the result ends with the digits: 2, 3, 4, round it to end with 5 (ie. 102, 103, 104, round to...
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
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...
I am trying to figure out how to have Excel round to the nearest decimal and separate the Billions/Millions with a decimal :confused::confused:. For example,
I would like 6,026,221,586.4 to become 6.03. Any ideas? Thank you!
I need to round up the last 3 digits. If the last two digits are >=50 then I need it rounded to the next hundred and if the last two digits are <50 then I need it rounded to the previous hundred.
If I have 22,560 in A1, then the formula in B1 should give me 22600.
If I have...
The formula of round currently rounds up if the decimal value is 0.5 and above and rounds down if the decimal value is below 0.5.
Is there a way to change this? I want a round up if the decimal value is 0.8 and above and round down if the decimal value is 0.7 and below.
If value is 2.7...
I need to convert a time into a decimal, but also add a specific rounding function. For example, A1 shows the hours and minutes worked in the form of 8:39 (meaning 8 hours, 39 minutes). I want to convert this to a decimal in B1 and also round to the nearest quarter hour.
I need to round the result of the following formula to 2 significant figures:
The following formula seems to work well for rounding to 2 sig figs:
How can I combine these formulas to yield a nicely rounded result...
Wondering if anyone can help with 2 macros I have that work but both have kinks that I would like to check
1) Number format macro
................ Selection.NumberFormat = "#,##0;[Red](#,##0);-;"
This macro is for formatting numbers in a way I like. However if I inadvertantly use it on...