Excel Rounding in Excel

[mwhite14_69]

I am not sure if I am posting right but here is my question. I am trying to do an "IF" function to calculate how many rooms are needed. If the amount of passengers (A1) are less than 4, 1 room, If more than 4 passengers (A1) divide the passenger (A1) by 4 then roundup the answer.
=IF(A1<=4,1,IF(A1>4,A1/4)
This will give the answer I need but evertime I try to insert the ROUNDUP function I get errors. Please if anyone can help, I have been working on this for hours.

 

[Ian]

Welcome to the forums

Does this work for you?

=ROUNDUP(IF(A1<=4,1,IF(A1>4,A1/4)),0)

 

[mwhite14_69]

Okay I figured out -

=IF(A1<=4,1,IF(A1>4,ROUNDUP(A1/4,0)))

Thanks for the help though, it only took me about 3 hours to figure this one out, I don't think I could have wrote it many more ways.