C
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!?!
point showing with the zeros after it!?!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
×
מיכ×ל (מיקי) ×בידן
Assuming 332.84 us in cell A1 - try these:
=TRUNC(A1)
=INT(A1)
=ROUNDDOWN(A1,0)
=FLOOR(A1,1)
Micky
=TRUNC(A1)
=INT(A1)
=ROUNDDOWN(A1,0)
=FLOOR(A1,1)
Micky
D
David Biddulph
=ROUND(A2,0) and format as number with 2 decimal places.
J
Joe User
chris gail said: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.
D
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"
In that case he can use: RoundUp or Ceiling as well...
Micky
והמשך/×™, × ×, ×œ×§×¨×•× ×ת השורה הב××”:
***********
×× ×ª×’×•×‘×ª×™ עזרה לחץ/×™, × ×, על <כן> בפס ×”×ופקי התחתון!
***********
מיכ×ל ×בידן
×ž× ×”×œ ×¤×•×¨×•× "×ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"