Nygie,

You can string what you are looking for into one formula: =IF(D2="Y",IF(Gross>865,753*0.01,IF(AND(Gross>113,Gross<865),Gross-(113*0.01))),0)

So this is how this formula calculates:

First determines if there is a "Y" in cell D2: =IF(D2="Y"

If yes, first check to see if Gross is Greater than 865: IF(Gross>865,

if True then multiply 753 x 1%

If not True, Check to see if Gross is Greater than 113 and Less than 865: IF(AND(Gross>113,Gross<865) Notice the construct of an IF(AND statement. You enter 2 logical checks separated by a comma then followed by ")" to complete the "AND" portion of the formula.

Now, if both checks of Gross are True (Gross is Greater than 113 and Less than 865) then: Gross-(113*0.01)

Finally, if there is not a "Y" in cell D2 enter a "0": ,0)

Hope this works and the explanation helps.