Excel can not multiply?

[oldny]

I am working on a new spreedsheet and wanted to multiply the total of 22
columns by a constant. No mater what constant I put into the formula
=SUM(E53* ) Excel gives me the wrong answer. Now I have cleared contents in
every cell thinking it may be something left over but that did not help. I
have used two calculators and two human calculations and they come up with
the same answer which is different from the Excel answer. Has anyone else
experienced this problem?

 

[RagDyeR]

Post your *exact* formula.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

I am working on a new spreedsheet and wanted to multiply the total of 22
columns by a constant. No mater what constant I put into the formula
=SUM(E53* ) Excel gives me the wrong answer. Now I have cleared contents
in
every cell thinking it may be something left over but that did not help. I
have used two calculators and two human calculations and they come up with
the same answer which is different from the Excel answer. Has anyone else
experienced this problem?

 

[Billy Liddel]

=SUM(C2*2) works OK for me or =SUM(C2:C5*2) committed as an array (Ctrl +
Shift + Enter)

regards

 

[oldny]

the exact formula is =SUM(E53*1525)
E53 is 2,526
multiply by 1,525 and Excel comes up with 3,852,531
I come up with 3,852,150 and so does my calculators and Excel 2003
I can not figure this out. If I change the constant to 1,001 I still get
the wrong answer.

 

[oldny]

After I put in a formula I always hit Enter, not (Ctrl + Shift + Enter), does
it make a differnce in Excel 2007?

 

[Don Guillett]

leave out the sum

=SUM(E53*1525)
=E53*1525

Don Guillett
SalesAid Software
(e-mail address removed)

 

[Sandy Mann]

3,852,531/1525 = 2526.25

Is E53 the result of a calculation formatted to show no decimals?

Format as general to see what it in the cell.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Elkar]

Two things. First off, it is redundant to use the SUM function is this
situation. =E53*1525 and =SUM(E53*1525) result in the same answer.

Second, what is the actual value of E53? I'm guessing that the cell format
rounds to the nearest whole number? So, what is displayed (2526) is not what
is actually contained in the cell. It is likely (2526.25).

Try using the ROUND() function on cell E53. That way, the actual contents,
and the displayed contents will be the same.

HTH,
Elkar

 

[oldny]

I had to change the number in cell E53 to 2436.25 and I formated this cell to
general
In cell E55 I enter the formula =E53*1525 and formated that cell to general
and Excel came up with 3715281.25 which is right
You were correct in thinking that the cell was incorectly formatted. Thank
you very much and all I can say is DUH

 

[Billy Liddel]

Array formulas take more memory than an ordinary formula, don't use them
unless you have to.

I'm sure XL2007 is the same.

Peter

 

[Sandy Mann]

You were correct in thinking that the cell was incorectly formatted.

You're not the first <g>
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Nick Hodge]

Billy

I'm not sure they use more memory as they are one formula referencing the
array???

They are more difficult to work with after they are in place, but I believe
they are more efficient in memory

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[JLatham]

Array formulas have been around longer than just Excel 2007. They are a
special type of formula that takes special care and feeding when creating and
editing: you "commit" one using the 3-key combination mentioned instead of
just the [Enter] key both when you create the formula and when you edit one.
As has been said, for the most part a regular formula works just fine. Just
be aware that when someone mentions "array formula" or "this is an array
formula..." that you have to use the 3-key combination to get it into the
worksheet/cell properly.