Feb 15 2022 09:00 AM
=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.