| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I round off a number to 333.00 instead of 332.84?
How do I round off a number to 333.00 instead of 332.84? I need the decimal
point showing with the zeros after it!?! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I round off a number to 333.00 instead of 332.84?
Assuming 332.84 us in cell A1 - try these:
=TRUNC(A1) =INT(A1) =ROUNDDOWN(A1,0) =FLOOR(A1,1) Micky "chris gail" wrote: How do I round off a number to 333.00 instead of 332.84? I need the decimal point showing with the zeros after it!?! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I round off a number to 333.00 instead of 332.84?
=ROUND(A2,0) and format as number with 2 decimal places.
-- David Biddulph "chris gail" <chris wrote in message ... How do I round off a number to 333.00 instead of 332.84? I need the decimal point showing with the zeros after it!?! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I round off a number to 333.00 instead of 332.84?
|
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I round off a number to 333.00 instead of 332.84?
Wouldn't those give 332 instead of 333, Micky?
-- David Biddulph "????? (????) ?????" <micky-a*at*tapuz.co.il wrote in message ... Assuming 332.84 us in cell A1 - try these: =TRUNC(A1) =INT(A1) =ROUNDDOWN(A1,0) =FLOOR(A1,1) Micky "chris gail" wrote: How do I round off a number to 333.00 instead of 332.84? I need the decimal point showing with the zeros after it!?! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I round off a number to 333.00 instead of 332.84?
Of course - my mistake (didn't notice the exact number)
In that case he can use: RoundUp or Ceiling as well... Micky והמשך/י, *א, לקרוא את השורה הבאה: *********** אם תגובתי עזרה לחץ/י, *א, על <כן בפס האופקי התחתון! *********** מיכאל אבידן מ*הל פורום "אופיס" ב"תפוז" [Microsoft" Most Valuable Professional [MVP" "David Biddulph" wrote: Wouldn't those give 332 instead of 333, Micky? -- David Biddulph "????? (????) ?????" <micky-a*at*tapuz.co.il wrote in message ... Assuming 332.84 us in cell A1 - try these: =TRUNC(A1) =INT(A1) =ROUNDDOWN(A1,0) =FLOOR(A1,1) Micky "chris gail" wrote: How do I round off a number to 333.00 instead of 332.84? I need the decimal point showing with the zeros after it!?! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round number to the thousands without changing underlying number | Excel Discussion (Misc queries) | |||
| Excel. How to round a number to nearest half number? | Excel Discussion (Misc queries) | |||
| Can I increase a number by 5.5% and then round that number to the. | Excel Discussion (Misc queries) | |||
| How can i round a number to closest tenth number? | Excel Worksheet Functions | |||
| How to make a number round up/down to a set number | Excel Worksheet Functions | |||
Linear Mode
