Excel can not multiply?
 

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?

Excel can not multiply?
 

Post your *exact* formula.
--

Regards,

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

"oldny" wrote in message
...
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?

Excel can not multiply?
 

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

regards

"oldny" wrote:

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?

Excel can not multiply?
 

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.

"RagDyeR" wrote:

Post your *exact* formula.
--

Regards,

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

"oldny" wrote in message
...
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?

Excel can not multiply?
 

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

"Billy Liddel" wrote:

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

regards

"oldny" wrote:

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?

Excel can not multiply?
 

leave out the sum

=SUM(E53*1525)
=E53*1525

Don Guillett
SalesAid Software

"oldny" wrote in message
...
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.

"RagDyeR" wrote:

Post your *exact* formula.
--

Regards,

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

"oldny" wrote in message
...
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?

Excel can not multiply?
 

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


with @tiscali.co.uk


"oldny" wrote in message
...
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.

"RagDyeR" wrote:

Post your *exact* formula.
--

Regards,

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

"oldny" wrote in message
...
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?

Excel can not multiply?
 

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" wrote:

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.

"RagDyeR" wrote:

Post your *exact* formula.
--

Regards,

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

"oldny" wrote in message
...
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?

Excel can not multiply?
 

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

"Sandy Mann" wrote:


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


with @tiscali.co.uk


"oldny" wrote in message
...
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.

"RagDyeR" wrote:

Post your *exact* formula.
--

Regards,

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

"oldny" wrote in message
...
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?

Excel can not multiply?
 

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

"oldny" wrote:

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

Excel can not multiply?
 

"oldny" wrote in message
...

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


with @tiscali.co.uk

Excel can not multiply?
 

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
DTHIS
www.nickhodge.co.uk


"Billy Liddel" wrote in message
...
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

"oldny" wrote:

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

Excel can not multiply?
 

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.

"oldny" wrote:

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

"Billy Liddel" wrote:

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

regards

"oldny" wrote:

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?