roundup / down

[monkeyharris]

I have the below formula but need to also make it round up / down depending on the result.

example: if the result is between 15.51 & 16.49 i need it to round to the nearest round figure (16) but if between 16.50 and 17.49 i need it to round to 17.00 and so on.....

=IF(ISERROR(AA26/Z26),0,AA26/Z26)

 

[texasalynn]

set your cell to 0 decimals, as that is the natural rounding in Excel

 

[carsten]

or if you want to go on with the rounded value for ongoing calculations use:

=IF(ISERROR(AA26/Z26),0,round(AA26/Z26,0))

 

[Ranger32195]

Try using =IF(ISERROR(AA26/Z26),0,ROUND(AA26/Z26,0))