halving contents of a cell
Done it!!! Doh!! Divide the cell by 2 and round it by 0..........
Had a blonde moment!!
Louise
"Louise" wrote:
How do I ask Excel to half the contents of a cell and then round the answer
up??
For instance, if I have 17 in a cell, I want it to half the 17 and then
round the answer up to 9 instead of returning 8.5.
Urgent help please.............!!
Thank you.
Louise
|