Need roundup formula

[mikerules]

J5=74
J4=67
J5/J4 = 0.905

I need the formula to round up to 1 if below 1

[BadlySpelledBuoy]

Assuming you don't want any numbers rounded if they are greater than or equal to 1 then you could use =IF(J6/J5<1,1,J6/J5)

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[Philb1]

If you want to round up to the next whole number from anything below

Please Login or Register  to view this content.

To get the result you show

Please Login or Register  to view this content.

[TMS]

@Philb1:that would round any result to 0 decimal places, not just numbers below 1

[Philb1]

I didn't think of restricting it to only below 1. I thought maybe it would be any number below a whole number. If I read the post properly it might have helped.
My bad :-(

[mikerules]

Thank-you that works perfectly