IF and ROUND statements together

[chadski778]

I need a formula that divides the value of a cell (eg A1) by 3 and if the answer is <1 it must return a value of 0, but if the answer is >1 I want it rounded up to the nearest whole number. So an answer of 1.415 would return 1 and answer of 1.66 would return 2 and an answer of 2.33 would return 2 and an answer of 2.57 would return 3 for example. I have tried an IF and ROUND statement but I can't seem to make it work

Any ideas would be gladly received

 

[Eric W]

Maybe:

=IF(A1<3,0,ROUND(A1/3,0))

 

[chadski778]

Thank you very much that's exactly what I need. Much appreciated

 

[Eric W]

You're welcome.