Option to remove the rounding function?

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:49 PM GMT

QuestionEdit

When creating a formula init automatically rounds, is there an option to just drop the decimals with out rounding? example: if my answer is 123.5 I want it to read 123. But I dont want to round down because I want 123.3 to read 123 also.

AnswerEdit

Sure. Use the TRUNC function to truncate numbers (chop off the decimal points).

=TRUNC(A1,0)

Advertisement

©2024 eLuminary LLC. All rights reserved.