I have a number that represents a %.For example if the value is say 88.67, I should represent the value as 89. If the value was 88.4, I should display as 88.
This means if the decimal part of the value is more than 0.5, then add 1 to 88. otherwise display as 88
I thought this was a simple excel solution. But did not work.
This is what I used, but does not get evaluated.
=IF(G8-TRUNC(G8)>0.5,(G8-TRUNC(G8)+1),TRUNC(G8)); G8 is the cell.
Bookmarks