# Answered! What would the formula be in excel to round a calculated number up to a certain number? I need a method to tell a…

What would the formula be in excel to round a calculated number up to a certain number? I need a method to tell a cell to round to the numbers 1, 2, 4, or 6. So if the number is less than 1, then round up to 1. If the number is between 1 and 2, then round up to 2. If between 2 and 4, then round up to 4. If between 4 and 6, then round up to 6. If above 6, then show error message that says “choose other perameters”.

I don’t care if it’s a series of formulas in different cells, I just need it to work every time. My current formula errors out randomly.

Don't use plagiarized sources. Get Your Custom Essay on
Answered! What would the formula be in excel to round a calculated number up to a certain number? I need a method to tell a…
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS \$13/PAGE
 =IFS(AND(Np_C>1,Np_C<6),ROUNDUP(Np_C,1),Np_C>1,MROUND(ROUNDUP(Np_C,0),2),Np>6,”Choose Smaller Dimensions”) If it helps, I’m using excel 2016

The formula you need is

=IF(Np_C <= 1, 1, IF(Np_C <= 2, 2, IF(Np_C <= 4, 4, IF( Np_C <= 6, 6, “Choose Smaller Dimensions”))))

Please don’t forget to rate the answer if it helped. Thank you very much.