multiply
 

i have 3.75 in one cell and then in another cell i have =b2/2 and the answer
is 1.88.

i am trying to multiply it by 5 and when i do this i put =c2*5 and it gives
me the answer 9.375 and when i check my calculator it is wrong.

how can i get the right answer?

even when i put 1.88*5 it still gives me 9.375. what am i doing wrong?

multiply
 

Check your division in the first equation. You'll see that 3.75 / 2 is NOT
1.88. In fact it is, 1.875. 1.88 is 1.875 rounded to the nearest
hundredth. Even though you are seein g 1.88 due to it being rounded, Excel
still calculates the actual value of 1.875 * 5, which is 9.375.

So now the question is, what do you want it to return?

Regards,
Paul

--

"JoRDaN" wrote in message
...
i have 3.75 in one cell and then in another cell i have =b2/2 and the
answer
is 1.88.

i am trying to multiply it by 5 and when i do this i put =c2*5 and it
gives
me the answer 9.375 and when i check my calculator it is wrong.

how can i get the right answer?

even when i put 1.88*5 it still gives me 9.375. what am i doing wrong?

multiply
 

JoRDaN wrote:
i have 3.75 in one cell and then in another cell i have =b2/2 and the answer
is 1.88.

i am trying to multiply it by 5 and when i do this i put =c2*5 and it gives
me the answer 9.375 and when i check my calculator it is wrong.

how can i get the right answer?

even when i put 1.88*5 it still gives me 9.375. what am i doing wrong?

3.75 / 2 = 1.875, not 1.88, although that could be what is displayed in your
cell. Add decimal places to the cell format and you should see 1.875 (if you
really have exactly 3.75 in B2).

multiply
 

You probably have cell C2 formatted as a number to show only 2 decimal
places. The correct answer of 3.75 / 2 is 1.875, but this is being
rounded up to show 1.88 (although the cell still contains the correct
value). When you then multiply by 5 you get the correct answer of
9.375.

Format cell C2 to show at least 3 decimal places.

Hope this helps.

Pete

On Dec 8, 3:33*pm, JoRDaN wrote:
i have 3.75 in one cell and then in another cell i have =b2/2 and the answer
is 1.88.

i am trying to multiply it by 5 and when i do this i put =c2*5 and it gives
me the answer 9.375 and when i check my calculator it is wrong.

how can i get the right answer?

even when i put 1.88*5 it still gives me 9.375. *what am i doing wrong?

multiply
 

Well, 3.75/2 *IS* 1.875, and that's what is stored in C2.

Your displayed value is rounded to 2 digits to show 1.88, but XL will
still perform calculations based on the stored value.

You can use this instead:

C2: =ROUND(B2/2, 2)


In article ,
JoRDaN wrote:

i have 3.75 in one cell and then in another cell i have =b2/2 and the answer
is 1.88.

i am trying to multiply it by 5 and when i do this i put =c2*5 and it gives
me the answer 9.375 and when i check my calculator it is wrong.

how can i get the right answer?

even when i put 1.88*5 it still gives me 9.375. what am i doing wrong?

multiply
 

The reason that 9.375 is correct is that 3.75/2 is 1.875 and not 1.88

The reason that Excel is telling you the answer is 1.88 is that is the
display format and not the value.

Your display format is "hiding" the precise value.
--
Gary''s Student - gsnu200818


"JoRDaN" wrote:

i have 3.75 in one cell and then in another cell i have =b2/2 and the answer
is 1.88.

i am trying to multiply it by 5 and when i do this i put =c2*5 and it gives
me the answer 9.375 and when i check my calculator it is wrong.

how can i get the right answer?

even when i put 1.88*5 it still gives me 9.375. what am i doing wrong?

multiply
 

What you are doing wrong is not looking at enough decimal places.
Why not divide 3.75 by 2 yourself (rather than with Excel) and see what it
comes to?

One thing you should check is where you said "even when i put 1.88*5 it
still gives me 9.375". Are you sure that you actually have =1.88*5 in the
formula bar? That ought, of course, to give 9.4.

If you actually want to round to 2 places of decimals before your further
calculations, then you can use the ROUND function. If you have cells
formatted to 2 places you could use the "Precision as Displayed" option, but
I woukldn't recommend it.
--
David Biddulph


"JoRDaN" wrote in message
...
i have 3.75 in one cell and then in another cell i have =b2/2 and the
answer
is 1.88.

i am trying to multiply it by 5 and when i do this i put =c2*5 and it
gives
me the answer 9.375 and when i check my calculator it is wrong.

how can i get the right answer?

even when i put 1.88*5 it still gives me 9.375. what am i doing wrong?