Thanks, that worked. I guess I was trying to make it too difficult.

"jnu" wrote:

try this =IF(Q5<8,0,IF(Q5<16,E5*0.5,IF(Q5<50,E5*0.75,E5)))



"Kim" wrote:

I am trying to create an IF formula that if a column is <16 but 49 then
multiple by .75 or if the number is <8 but 15 ten multiple by .50, if
greater than 50 100%, if less than 8 = 0.

Here is the formula that I have created
=IF(Q550,E5,IF(Q516<49,E5*0.75,IF(Q58<15,E5*0.5 ,IF(Q5<8,0))))

It is working for all instances except numbers that are betwen 16 and 49.
Can someone help?