Calculate and rounding function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to calculate and round a cell? The example I have is: Cell E10 has a value of 55.02 which is the result of 65.5*0.84. I want the value shown in E10 is 55.00 so I put in =(65.5*0.84),round(E10, 2) and of course it didn't work. What did I miss here?

Help!
 
one way in e10
=INT(65.5*0.84)
or
=ROUND(65.5*0.84,0)

MW said:
How to calculate and round a cell? The example I have is: Cell E10 has a
Click to expand...
value of 55.02 which is the result of 65.5*0.84. I want the value shown in
E10 is 55.00 so I put in =(65.5*0.84),round(E10, 2) and of course it didn't
work. What did I miss here?
 
Use =ROUND(E10, 1) and format the cell for a number of 2 decimal places.


David Hager
Excel MVP


MW said:
How to calculate and round a cell? The example I have is: Cell E10 has a
Click to expand...
value of 55.02 which is the result of 65.5*0.84. I want the value shown in
E10 is 55.00 so I put in =(65.5*0.84),round(E10, 2) and of course it didn't
work. What did I miss here?
 
Back
Top