Forum Discussion
Anonymous
Jul 08, 2018Conditional Rounding
Hello there. I am trying to forecast full-time employees and I need round the cells with the FTE (full time employees) numbers in them. I only want to round up if the decimal value is greater than ....
SergeiBaklan
Jul 09, 2018Diamond Contributor
Hi Ben,
As variant
=IF(A1-INT(A1)>0.25,ROUNDUP(A1,0),A1)