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)

[Philb1]

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

=ROUNDUP(J5/J4,0)' Rounds up to the next whole number

To get the result you show

=ROUNDUP(J4/J5,0)

[mikerules]

Thank-you that works perfectly

[TMS]

=MAX(J5/J4, 1)

Regards, TMS

[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 :-(