We're trying to create a formula using the IF function and can't seem to get it right.
What we're trying to accomplish is if the product is 0(zero), then enter 0.00; if the product is between 1-175, then enter 175.00; if over 175, then enter the actual product.
This is what we're attempting to...