How can I tell Excel NOT to round up when it calculates?
Click Tools menu,
Choose Calculation tab
Check "Precision as Displayed"
> How can I tell Excel NOT to round up when it calculates?
Excel does *not* round up, unless you tell it to so in the formula, like
with the ROUNDUP() function.
It may seem that it rounds (not UP, just plain round); because no more
digits fit in the column width or because you told Excel (via Formatting)
not display more than a certain number of digits.
"In the background" there is still an ...Round to 2 decimal places
I want to round the calculation to 2 decimal places:
(215 * 3.134)/100
Any function I can use with?
Have you looked at the Round() function?
Alan T wrote:
>I want to round the calculation to 2 decimal places:
>(215 * 3.134)/100
>Any function I can use with?
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.
Message posted via AccessMonster.com
A slightly more complex response...
Do you want to use Bankers rounding or Arithmetic rounding...Round to million
How do I round numbers to millions e.g. =A32,500,000 would=20
Thanks for your help
one way would be to divide by a million
<firstname.lastname@example.org> wrote in message
How do I round numbers to millions e.g. �2,500,000 would
Thanks for your help
With Arial as font......
Custom Format as ALT + 0163#.0,,"m"
ALT + 0163 on the NumPad, then type in the rest.
Gord Dibben Excel MVP
On Tue, 22 Jun 2004 07:2...subtracting dates to get a age
I am trying to subtract the current date from the person birth date to get a
person age (in years not days). Is there a formula for this?
Thanks in advance
In article <9782D2DB-48FF-4D17-96FB-AB8BBF88333D@microsoft.com>,
"Lori" <Lori@discussions.microsoft.com> wrote:
> I am trying to subtract the current date from the person birth date to get a
> person age (in years not days). Is there a formula for this?
> Thanks in advance
I wish to have the numbers rounded to the nearest 10 (or
nearest 100 or nearest 1000. (Ex.) 1069.06 I wish to have
rounded NOT to 1069 but to 1070 (the nearest 10). I can't
seem to find the fix for this. Please help.
"Burgh Man" <email@example.com> wrote in message
> I wish to have the numbers rounded to the nearest 10 (or
> nearest 100 or nearest 1000. (Ex.) 1069.06 I wish to have
> rounded NOT to 1069 but to 1070 (the nearest 10). I can't
> seem to find the fix for this. Please help....My 4 row formula is not ROUNDING out
Row D Row E Row F Row G
$120.00 $11.67 $10.32 $185.70
120 =(D16/18)+5 =(D16/18)+3.65 =F16*18
These are my 4 rows of cells. Top row shows my results the bottom row shows my formulas. My 4th row formula is not rounding out properly. How can I get this to fix?
"stacey robinson" <firstname.lastname@example.org> wrote:
> Row D Row E Row F Row G
> $120.00 $11.67 $10.32 $185.70
> 120 =(D16/18)+5 =(D16/18)+3.65 =F16*18
> My 4th row formula is not rounding out properly.
E16: =R...Round to Thousands and x-foot the sum of the total
Round(a1,-3) will round to the thousands,
Round((sum(a1:a39)),-3) will round the total to thousands
but I do not know what you mean by 'x-foot'
Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread: http://www.excelforum.com/showthread.php?threadid=385486
X-foot is shorthand for "cross foot", meaning the sum should be the
same whether you add the elements horizontally or vertically. It's a
checksum process to ensur...Pats on the back all round
During the last few days, I've found myself asking questions in various
other groups with a linux problem. The responses have been tight arsed with
respect to information, or non-existant. The contrast was striking. I really
thought the linux community would be more cooperative, but it's not at all.
A BIG congrats to all contributors to this group, and particularly our MVP
...program terminates unexpectedly
Operating System: Mac OS X 10.3 (Panther)
Processor: Power PC
my wife has a LOT of word documents and powerpoint presentations that she created on her computer using office for mac 2004. now whenever she tries to open one of them, the program starts up then terminates itself. if she opens the program first then tries to open the file, it attempts to open then terminates the program. if you open the program then create a new file it terminates when you try to save it.
it was working one day and then it wasn't.
Hmm....let's work on Word first--try the standard troublesho...Subtracting Holiday Hours
I'm using the following expressions to calculate the number of hours between
[ZeroHour] and [ActualEndDate] subtracting the Saturday and Sunday Hours. I
also have a table [tblHolidays] with a [HolidayDate] field. Is it possible to
create an expression that would allow me to subtract holiday hours also? Do I
need to create a function?
Count the holidays betwe...Union and Intersect range... but any SUBTRACT?
I see the functions to union and intersect a range, but I don't see a
function to subtract one range from another.
Does anyone know if this function exists, or if there is a VBA function out
there to do this I can paste into my application?
Found in a search of newsgroup archives
search all words: union intersect subtract
Tom Ogilvy posted a SubtractRange subroutine in a
reply 2000-08-06 that should work for you.
http://google.com/groups?threadm=%23OOGqH7%24%24...Subtotal by date shows US format rather than other way round
I have a spreadsheet which has data subtotalled by date. My date format
is dd/mm/yyyy, but the subtotals show mm/dd/yyyy. When I look in
'format cell' it shows my format is dd/mm/yyy, but even still it shows
the other way around.
How do I fix this?
...Rounding Errors Help
Is there any way to display a rounded number in a cell, but use th
original unrounded number when other cells reference that cell in
calculation? It would be a pain to use the components of the rounde
cell in the calculation in which i would need the unrounded number.
I need a function that displays a rounded number, but uses th
unrounded number in calculations
mattflow's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2512
View this thread: http://www.excelforum.com/showthread.ph...Basic example formula needed to link between sheets add/subtract
I've tired =j6+g21 but from different sheets, so its possible when i change
one the other changes also. What formula do I need, because thats just not
Type the = sign, then go to the other sheet and click in J6, then hit the +
sign, and go to the relevant sheet and click in G21. Hit enter.
You should have a formula that looks something like
"gnagy84" <email@example.com> wrote in message
> I've tired =j6+g21 but from different sheets, so i...rounding #12
I'm having trouble with excel. I am taking information from one sheet
and using formulas to have it appear on another sheet in the format I
need. Right now I'm needing to take a number in this format:
12.25 12.25 2.75
9 6 6
8.75 8.75 .25
and have it appear in the other sheet in this format:
12.3 12.3 2.75
9.00 6.00 6.00
8.75 8.75 0.25
The final cells are to be right-justified, zero-filled, and kept to 4
characters including the decimal (hence the need for rounding for the
12.25 to get to 12.3)
How would I do this?
On 31 Jul 2006 11:41:11 -0700, "tankgirl215" <...VBA isn't subtracting properly
I have this small function in a worksheet (as this is where the rest of
my code is written) that's just not wanting to work.
It is as follows:
Private Function fncIsCountingNumber(dSomeNumber As Double, dTotal _
As Double) As Boolean
Dim dRoundQ As Double, dQ As Double, dDiff As Double
If dSomeNumber = 0 Then
fncIsCountingNumber = False
dRoundQ = Round(dTotal / dSomeNumber, 0)
dQ = dTotal / dSomeNumber
dDiff = dQ - dRoundQ
If dDiff = 0 Then
fncIsCountingNumber = True
fncIsC...An unexpected error has occured
I have strange problem with one of our users. When one particular user would
like to upload documents under Project Documents folder placed on PWA
workspaces user recive error "An unexpected error has occured"
That problem exists on different computers, when I log on on user computer
and signed as my self I had no problems.
That is very strange that user has that problem and I and the others do not
(eaven when we use user IE and only use optio Sign on as..)
Do you know what may be the reason?
Thank you very much for help.
...Rounding within a range
Is it possible to analyze and round a number based on the following
If number is between *.25 and *.74 round to *.5
If number is between *.75 and *.99 round to next higher whole #.
If number is between *.01 and *.24 round to next lower whole #.
husker's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35872
View this thread: http://www.excelforum.com/showthread.php?threadid=556635
=IF(A1-TRUNC(A1)<0.25,TRUNC(A1),IF(AND(A1-TRUNC(A1)<0.75,A1-TRUNC(A1)>=0...Rounding Problem #3
This is a typical problem where I have a column of numbers that when
rounded, do not total to what you see on the screen. Rather than using
the precision as displayed option in Excel, I would like to use a
formula that uses the ROUND function that rounds each cell prior to
summing. Is there a function or formula that would replace
=(ROUND(A1,0))+(ROUND(A2,0))+(ROUND(A3,))...etc? I have tried
ROUND(SUM(A1:A20),0) but this rounds after the cells have been summed.
Thanks in advance
entered with ctrl + shift & enter
I have a table that has 3 elements that have been defined as Currency with 2
decimals. Everything worked in the queries perfectly. Now I have been told
they no longer wish to have a decimal at all. I tried changing the
definition to Double with 0 decimals. Then when I run my averaging query, I
still get decimals and rounding. Ideas?
In the underlying table change the currency's decimal property from Auto to
Arvin Meyer, MCP, MVP
"Bunky" <Bunky@discussions.microsoft.com> wr...Unexpected font size changes
Outlook 2007. When I compile an email using word 2007 as my editor I sometimes copy & past items including graphics & and text. When I check Print Preview all is well.
However when I send the email there are what appesr to be random and unexpected changes/enlargements in the font sizes. This may be from 8 to 24. It is very distressing.
Anyone know why this happens & what I can do about it.
...numbers being rounded
a chart that i am making has two kinds of numbers, one set is prices and
another set is the codes that our system reads to apply the prices. the
problem i am having has to do with the codes. Some codes have to have a .0
(as in 678.0) and some have to start with a zero (as in 054). but as soon as
i click out of the cell the numbers are rounded to 687 and 54. but those
zeros are important to our system. i tried to mess with the decimal places
but it just didnt help. Thank you
> a chart that i am making has two kinds of numbers, one set is prices
> ano...How do I round up numbers when dividing?
What I am doing is in regards to money. I am dividing an amount between two
people and sometimes the amount can't be divided equally so I want to be able
to have the formula automatically adjust.
So for instance: $5000.23 divided by 2 does not divide equally.
So person A should get $2500.12
and person be should get $2500.13
The same thing goes for $523.00
> So for instance: $5000.23 divided by 2 does not divide equally.
> So person A should get $2500.12
> and person be should get $2500.13
If the total amount is in A1 and you want Person A and Pe...Rounding a time calculation in .25 increments
Hello! I have tried a couple of rounding suggestions that I have foun
somewhere in here but can't seem to get anything working.
I have created a spreadsheet that calculates time differences. All o
the times are in quarter hours :00, :15, :30, :45. So a calculation o
8:45 AM to 2:30 PM comes out 5.45. I need this to be 5.75. Can'
figure it out although I am sure it is pretty simple.
On top of that, sometimes after times are calculated, I need t
subtract additional time. Say I want to take 30 minutes off so
"Discounted Time" cell would have -.50 as it's value ...Credit Card Overtendering & Rounded Up Funcionality
The control of Credit Card Overtender, It doesn't allow RMS-SO tendering
amounts rounded go up. (rounded down it works well)
Anybody knows how can I config RMS-SO for tendering amounts rounded up using
Thxs 4 ur tym
This is a multi-part message in MIME format.
Sorry, you can't.
Check Point Software
Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS)