I need the formaula for this statement... "If the net sales of A is greater
than $1,000,000, then they must pay an additional $50,000 on top of
percentage". I currently have Net "Sales * Royalties (%)" in the the cell.
Please Help!