Forum Discussion
ChrisMiller1980
Feb 15, 2022Copper Contributor
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 correctly. Trying to find out what I am doing incorrectly. Any and all help is greatly appreciated. Thank you.
1 Reply
- JMB17Bronze ContributorTo round up to the nearest 100, try:
=ROUNDUP(A1,-2)