How do I round off a number to 333.00 instead of 332.84?

[chris gail]

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!?!

 

[מיכ×ל (מיקי) ×בידן]

Assuming 332.84 us in cell A1 - try these:
=TRUNC(A1)
=INT(A1)
=ROUNDDOWN(A1,0)
=FLOOR(A1,1)
Micky

 

[David Biddulph]

=ROUND(A2,0) and format as number with 2 decimal places.

 

[Joe User]

How do I round off a number to 333.00 instead of 332.84?
=ROUND(A1,0)


I need the decimal point showing with the zeros after it!?!

Format as Number with 2 decimal places.

 

[David Biddulph]

Wouldn't those give 332 instead of 333, Micky?

 

[מיכ×ל (מיקי) ×בידן]

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"