Hey guys, I'm trying to round down and then divide a number by 2. =ROUNDDOWN(A22,0)/2 is the formula I'm trying to use. The issue with this is that if I input an odd number into A22, it doesn't round down (e.g. the formula changes 7 to 3.5). However, if I input a number that is even, e.g. 4.6, it rounds it down to 2. 4.5 also rounds down to 2 etc. Why does the formula not round down odd numbers?
If you want your final value rounded down, then try
=ROUNDDOWN(A22/2,0)
Does that work for you?
or maybe you want two rounddowns?
=ROUNDDOWN(ROUNDDOWN(A22,0)/2,0)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I think you want
=ROUNDDOWN(A22/2,0)
Here's the difference:
Using 7 as an example for A22's value
you had =ROUNDDOWN(A22,0)/2
which is =ROUNDDOWN(7,0)/2
which is =7/2
which is =3.5
should be
=ROUNDDOWN(A22/2,0)
which is =ROUNDDOWN(7/2,0)
which is =ROUNDDOWN(3.5,0)
which is =3
Last edited by Cutter; 05-22-2012 at 11:21 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks