Help with a formula please

[DAVE H]

I have 3 cells containing values. I need a formula that would give the result of combining these values according to the following four possiblities. The result wouild go into cell C23.
If cell C17< cell C13 and cell C6<1 then cell C23=Cell C6 *1000
If cell C17< cell C13 and cell C6>=1 then cell C23=cell C6
If cell C17>=cell C13 and cell C6<1 then cell C23=cell C6 *500
If cell C17>= cell C13 and cell C6>=1 then cell C23=cell C6
I hope that you can understand what I am trying to do.
I have tried to do it using and & if operator but can't seem to get the right results.

Yours hopefully DAVE H

 

[SteveO59L]

=IF(AND(C17<C13,C6<1),C6*1000,IF(AND(C17<C13,C6>=1),C6,IF(AND(C17>=C13,C6<1),C6*500,IF(AND(C17>=C13,C6>1),C6,"Something Else"))))

 

[lenze]

Hi and welcome to the board!!

=IF((C17< C13)*(C6<1),C6*1000,IF((C17<C13)*(C6>=1),C6,IF((C17>=C13)*(C6<1),C6*500,C6)))

lenze

 

[texasalynn]

I think this is what you asked

=IF(AND(C17 < C13,C6 < 1),C6*1000,IF(AND(C17 < C13,C6>=1),C6,IF(AND(C17>=C13,C6 < 1),C6*500,0)))

 

[DAVE H]

Thanks to all who replied to my post. With all your help I now have solved my problem. Also I have a little more understanding of how "IF" & "AND" work in a formula.
This was my first post as I have recently joined the forum. I was amazed at the quality & the speed of your responses.

Many thanks again Dave H.