LinkBack URL
About LinkBacks
J5=74
J4=67
J5/J4 = 0.905
I need the formula to round up to 1 if below 1
J5=74
J4=67
J5/J4 = 0.905
I need the formula to round up to 1 if below 1
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)
If you want to round up to the next whole number from anything belowTo get the result you show
=ROUNDUP(J5/J4,0)' Rounds up to the next whole number=ROUNDUP(J4/J5,0)
Thank-you that works perfectly
Formula:
=MAX(J5/J4, 1)
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
@Philb1:that would round any result to 0 decimal places, not just numbers below 1
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 :-(
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks