The Round(A1/2,0) method will work with whole numbers only. If your data is
14.6, your method will result in 7, which is rounded down instead of up.


"Louise" wrote:

Done it!!! Doh!! Divide the cell by 2 and round it by 0..........

Had a blonde moment!!