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.
Sure. Use the TRUNC function to truncate numbers (chop off the decimal points).
=TRUNC(A1,0)
Advertisement