Remove Certain Decimals

---

TRUNC can remove a certain number of decimals

=TRUNC(123.456,1) returns 123.4

=TRUNC(123.456,2) returns 123.45

Note that ROUND, ROUNDUP and ROUNDDOWN can round up or round down but TRUNC removes numbers completely.

=ROUND(123.456,1) returns 123.5

---

© Copyright andrewsexceltips.net All Rights Reserved.