I am reforming a quote sheet for my shop and I am trying to fix a cell on the form that looks at the labor charge and calculates a shop fee.
What I need is a formula that combines =MAX((H40+H41+H42)*9%,5) with something that returns 0 if H40+H41+H42=0.
=MAX((H40+H41+H42)*9%,5) is working.
Bookmarks