Looking for a roundup function

[jwardlow84]

Hi all,

I am looking for a round up function or a formula to take an addition and if the answer is below a certain value it will round the answer up to the specified value. But if the addition is greater than the value specified for the roundup function the function is ignored and the answer is just the addition.

For example.

I have 1 hour + 2 hours = 3 hours but I want to charge for a minimum of 4 hours so I want the answer rounding up to 4. However, if I have 2 hours + 3 hours I want to ignore the round up so that the answer is actually 5.

Any help that can be given would be greatly appreciated.

Thanks

James

[JohnTopley]

=MAX(4,A1+B1) where A1 & B1 is your data

[jwardlow84]

=MAX(4,A1+B1) where A1 & B1 is your data

Thank you that's perfect