ROUNDUP????

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3168796%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EROUNDUP%3F%3F%3F%3F%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3168796%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3E%3DIF(UPPER(D37)%3D%22X%22%2C(Q2*45)%2B(Q3*45)%2B(Q5*20)%2B(Q8*20)%2B(Q9*22.5)%2B(Q7*22.5)%2CR1)%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20use%20ROUNDUP%20with%20this%20equation%20to%20round%20up%20to%20the%20nearest%20100.%20For%20some%20reason%20it%20is%20not%20calculating%20correctly.%20Trying%20to%20find%20out%20what%20I%20am%20doing%20incorrectly.%20Any%20and%20all%20help%20is%20greatly%20appreciated.%20Thank%20you.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3168796%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3168990%22%20slang%3D%22en-US%22%3ERe%3A%20ROUNDUP%3F%3F%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3168990%22%20slang%3D%22en-US%22%3ETo%20round%20up%20to%20the%20nearest%20100%2C%20try%3A%3CBR%20%2F%3E%3DROUNDUP(A1%2C-2)%3C%2FLINGO-BODY%3E
Occasional Contributor

=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
To round up to the nearest 100, try:
=ROUNDUP(A1,-2)