Thread: Round Calculation

I have three columns C8, E8 and G8. C8 is a number and to gain the calculation I need for E8 I'm using the basic =C8*.75 which gives me 2621. Then for the calculation for G8 I'm using the calculation =E8*75000 which gives me 196,537,500, however the number were looking to get is 196,575,000. The only way I have been able to achieve this is by actually typing the result of E8 without the calculations, then it gives me the proper number. What am I doing wrong in the calculation.

I apologize if this is not worded properly, i've attached a screen shot so you can get a some what better idea.

Thank you

What you are seeing as 2621 is actually 2620.5 being displayed with no decimal places. In order to achieve the number you want, without understanding all of the fact of the situation, you could use the following in E8:

=ROUND(C8*.75,0)

HTH

Jason