Trouble with OR function

[Jukez]

I have two cells that are age specific of 50 years and 60 years old cell C10=50 and D10=60 .........

Money will be given to these people if they fall between the ages from 50 to 60 and i've tried this combination =IF(OR(E20<=C$10,E20>=D$10,E21<=D12),D$13,0)

The formula above is trying to suggest if the client(E20) falls between the ages 50 to 60 OR has an income(E21) over 20,000(D12) then they will receive D13 lump sum.... the second part works fine but I can't figure out how to get the ages between 50 and 60 years old. I realise the function isn't working because this function assumes any age from 50 and over or 60 and under which is everyone in the world..... please help? haha

[djbomaha]

Hi Jukez,

The formula below matches your description. The formula you posted appears to have the greater than and less than symbols reversed. The formula below first checks income, and if it is over the value in D12, then it awards the lump sum. If the income is less than that in D12, then it checks the age, if it is between 50 and 60, then it awards the lump sum.

Please Login or Register  to view this content.

Hope that provides some direction,

Dan

[gak67]

You could also do it this way:

Please Login or Register  to view this content.