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.
=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 |
Expert Answer
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.