J
JM_Mc
I am using an IF formula to calculate between two cells, one is J (width) the
other is K (length). Currently these formulas give an answer that then has
to be rounded up based on the decimal place. I need the formula to also
round up the amount to quarter increments. For example if the answer is 1.17
then the formula needs to make it 1.25, if it is 1.33 then the formula needs
to make it 1.5, and finally if it is 1.63 then the formula needs to make it
1.75. So how do I add or make the formula round up to quarter increments?
The formula that I am using is:
=IF(J41<=3,K41/4,IF(J41<=4,K41/3,IF(J41>4,K41/2)))
other is K (length). Currently these formulas give an answer that then has
to be rounded up based on the decimal place. I need the formula to also
round up the amount to quarter increments. For example if the answer is 1.17
then the formula needs to make it 1.25, if it is 1.33 then the formula needs
to make it 1.5, and finally if it is 1.63 then the formula needs to make it
1.75. So how do I add or make the formula round up to quarter increments?
The formula that I am using is:
=IF(J41<=3,K41/4,IF(J41<=4,K41/3,IF(J41>4,K41/2)))