Okay, so basically if C18 says Y, then it needs to multiply the order qty by .02 ($20 per 1000). it needs a minimum of $15, but after the first $20 it needs to round up to the nearest $20. So since the formula didn't like rounding up WITH the $15 minimum, I figured if I set it to round up to the nearest 20 ONLY if the order qty is 1000 or over, it would solve the problem, but now I"m getting a Value error, and I'm not sure how to fix it.
Can anyone help?

=IF(C18="Y",MAX(15,(PRODUCT(H6,0.02))),0),IF(H6=">1000",ROUNDUP(PRODUCT(H6,0.02)/20,0)*20)

Thanks