Excel formula help

I have fooled with this problem all day, and I am very sure it is something simple.

I am trying to calculate commission sale. Cells C5 through F5 are the input cells. The problem formulas are in cells C6 through F10.

I want to pay various % of the Gross based on dollars sold (Cells A6through A9).

I have some formulas in place that work as long, but here is the problem. In Cell C6 through C9 I am fine as loong as gross sales do not exceed $17,000. When they go over 17,000 theformulas fails.

In Cells D6 through D9 I tried things differently. The result is that anything under $17,000 screws up.

What am I missing, can anyopne help? I have attached the file.

ggw47,

Attached is a modified version of your workbook.

HTH,

Alan.