How to ROUNDUP an IF Formula

[wberg82]

=IF(B5=0.375,(C5*D5)+E5+(IF(B5=0.375,F5*0.057))+(IF(B5=0.375,G5*0.094))+(IF(H5="X",0.328125,0))+(IF(I5="X",0.453125,0)),0)

How do I get this formula to ROUNDUP to the nearest 0.25?

Thanks

 

[joeu2004]

Ostensibly:

=IF(B5=0.375,CEILING((C5*D5)+E5+(IF(B5=0.375,F5*0.057))+(IF(B5=0.375,G5*0.094))+(IF(H5="X",0.328125,0))+(IF(I5="X",0.453125,0)), 0.25),0)

But your formula can be greatly simplified, to wit:

=IF(B5=0.375, CEILING(C5*D5 + E5 + F5*0.057 + G5*0.094 + IF(H5="X",0.328125) + IF(I5="X",0.453125), 0.25), 0)

If is not necessary to test B5=0.375 multiple times, unless you made a mistake in your original logic.

Removing the redundant parentheses improves readability.