|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
January 7th, 2005, 09:52 AM
|
|||
|
|||
Rounding up a number in excel
Hi
I am using excel 2002 to do a simple caluculation This is probably a very simple problem I am having but I can't find away round it. I have a basic formula in excel please see example below: Cell B3 = 100000 Cell C3 = Formula = B3*3.9894 this gives the figure of 1,101,074. I want to round the figure in C3 to 1,101.07 So basically all I am trying to do is get rid of the 4 proceeding 07at the end of the calculation Not sure if this is confusing. It is easier to explain in excel. PM
|
|
#2
January 7th, 2005, 12:34 PM
|
||||
|
||||
|
I'm confused. If B3 is 100000 and C3 contains a formula containing B3 * 3.9894 then this would result in 398940? If you ZIP the Excel file you can add it as an attachment to your post
__________________
selwonk If I've posted some code above, you might think it looks a bit simplistic. It might be. I'd rather people tried the next step themselves rather than getting a full solution on a plate. That way they learn more!
|
|
#3
January 8th, 2005, 04:14 AM
|
|||
|
|||
|
Use this in cell C3
=ROUND(B3, 2) The 2 is the number of decimals to round it to I can't remember but I think there is a MROUND function as well
|
|
#4
January 10th, 2005, 06:06 AM
|
|||
|
|||
|
Hi Mike
You are correct. I need to roind this up to 398.94. I do not want the last number to be displayed as this is a monetary value. Thanks PMSM Quote:
|
|
| Viewing: ASP Free Forums > Other > ASP Free Lounge > Rounding up a number is excel |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
