[LMB] OT: AKICIF: Office 2007, Excel to specific
ronda.mccarthy at gmail.com
Mon Apr 20 05:40:58 BST 2009
I have Excel 2007. I looked at Help for Quotient, and it says this formula
returns the Integer portion of a division. However, when I use the formula
SUM(A1/B1), where A1 is 44.55 and B1 is 2, I get 2.275. So maybe you just
need to use a different formula? I never used Quotient with any other
version of Excel, so I don't know if this is new behavior.
On Sun, Apr 19, 2009 at 8:22 PM, A. Sasha Wagner-Adamo <
acswagner at bellsouth.net> wrote:
> Hi list mind!
> I recently installed Office 2007 on my new laptop and have now run
> into the first problem in Excel that I cannot solve. I'm sure there's a
> really easy explanation, but I can't find how to fix it.
> My problem is with the quotient function. For example I tell it to
> divide 225.5 by 16 and it gives me 14.00 as an answer when it
> should be 14.09 or 44.55 by 2 for which it gives me 22.00. Clearly,
> it's rounding the results, but I cannot find where to tell it not to
> round. I thought adding zeros would fix that issue (like it used to in
> the older Excel versions, but no luck).
> Lois-Bujold mailing list
> Lois-Bujold at lists.herald.co.uk
More information about the Lois-Bujold