Can someone help me please as I don't know how to construct the formula to round up or down within an if statement?
I have a spreadsheet with data in column F and if the data is greater than .5, i want it to round up to the next whole number. if it is less than 0.5 then it would round down e.g. 2.20 in column F would round to 2, 0.99 would round up to 1.
Can anyone help me construct this formula please as I don't know if I should be using roundup, floor, ceiling or some other function?
Thanks in advance.
Bookmarks