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)
Formula:
Please Login or Register to view this content.
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
If you want to round up to the next whole number from anything belowTo get the result you show
Please Login or Register to view this content.Please Login or Register to view this content.
@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 :-(
Thank-you that works perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks