Forum Discussion
DonR1299
Dec 04, 2025Occasional Reader
Specific Rounding Rules
Howdy! My job has a bit of a weird rule for their rounding technique. I was curious if there is a way I can format my cells or write a function that allows for it. The rule is as follows: If the nu...
polis2025
Dec 05, 2025Occasional Reader
For rounding to whole numbers:
=IF(A1-INT(A1)=0.5, IF(MOD(INT(A1),2)=0, INT(A1), INT(A1)+1), ROUND(A1,0))