Cell_multiplication

  • Thread starter Thread starter mario069
  • Start date Start date
M

mario069

Hi
Something is wrong. When I multiply the two cells is not the same as
when I multiply the same numbers from the cell. Please take a look on
the attached work sheet.
The formula in cell C11 (25,463) = C10 (26) x C5 (970)

I cannot attach to this forum *xls format so if you can help me please
let me know and I will send you the *.xls format by email.

Thank you
Marin


+-------------------------------------------------------------------+
|Filename: Book1.pdf |
|Download: http://www.excelforum.com/attachment.php?postid=3582 |
+-------------------------------------------------------------------+
 
I can only think of one explanation:
The numbers you see are rounded.

Try this:
Select each of the referenced cells (C5, C10) and look in the formula
bar to see the actual number.
If it is a formula, press the [F9] key while editing the cell to see
the results of the formula (then press [Esc] to put everything back the
way it was). I'm guessing you'll see something other than the displayed
numbers.

Does that help?

Regards,
Ron
 
You are both right. How can I fix this, because I need rounded number to
use not decimal numbers? The 26 is actually 26.25 (the cell is a
formula), but I need to use that cell as rounded number in the next
formula. So how can I do that?

Thank you,
:cool:
 
Here are a couple ideas that might work for you:

If the cells are using 5/4 rounding (5+ means round up, under 5 means
round down) you could use this kind of formula:
C11: =ROUND(C10,0)*ROUND(C5,0)


If the cells always round down, try this:
C11: =INT(C10,0)*INT(C5,0)


Does that help?

Ron
 
Then you should round all your formulas.

For example, if the formula that returned the 26.25 was:
=A1+B1
Where A1 = 13
And B1 = 13.25

Change it to:
=ROUND(A1+B1,0)
--

HTH,

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

message
You are both right. How can I fix this, because I need rounded number to
use not decimal numbers? The 26 is actually 26.25 (the cell is a
formula), but I need to use that cell as rounded number in the next
formula. So how can I do that?

Thank you,
:cool:
 
TYPOS!

Corrected formulas:

5/4 Rounding:
C11: =ROUND(C10)*ROUND(C5)


Rounding down:
C11: =INT(C10)*INT(C5)
 
My apologies, RagDyer....not your typos....Mine.

I posted that from the other forum where this thread originated, which
blindly added it on to the last post (yours, in this case). In no way was
it meant to reflect on your fine work.

Regards,
Ron
 
<<<"In no way was it meant to reflect on your fine work.">>>

Saying this means that you haven't read too many of my posts.<bg>
 
Back
Top