Forum Discussion

ChrisMiller1980

Copper Contributor

Feb 15, 2022

ROUNDUP????

=IF(UPPER(D37)="X",(Q2*45)+(Q3*45)+(Q5*20)+(Q8*20)+(Q9*22.5)+(Q7*22.5),R1) I have tried to use ROUNDUP with this equation to round up to the nearest 100. For some reason it is not calculating cor...

excel

JMB17

Bronze Contributor

Feb 15, 2022

To round up to the nearest 100, try:
=ROUNDUP(A1,-2)