Forum Discussion
Brackets.
I'm using an 'IF' argument and I want the 'NO' response to provide a quantity rounded up to the next multiple of 10. I've got as far as "=IF(E5>80,0," My E5 quantity is less than 80 and I want the ...
As for the formula style, better is to use spaces and/or multiline to avoid extra errors with formula parts
=IF(E5>80,0,CEILING.MATH(E5,10))
=IF(E5 > 80, 0, CEILING.MATH(E5, 10) )
=IF(
E5 > 80,
0,
CEILING.MATH(E5, 10)
)
Variant of above could be
=10*(E5<=80)*(INT((E5-1)/10)+1)
=10 * (E5 <= 80) * (INT((E5 - 1) / 10) + 1)
=10 *
(E5 <= 80) *
( INT((E5 - 1) / 10) + 1 )