Assistance Combining Two Codes

[honkin]

Hi

I have 2 lots of code that I need to combine to give a result, but it is beyond my skill to do it. I assume it will be using OR somehow, but just not 100% exactly how to do it.

=IF(AND(G1256="LOST",F1256<=10),95,0)
=IF(AND(G1256="WIN",F1256<=10),-100*F1256+100,0)

Both sections seem to work well on their own, so just need them to work as a single calculation.

Basically, what I am trying to do in English is the following:-

If the word LOST is in cell G*** and the price in F*** is less than or equal to 10, put 95; if it's above 10, put zero. But if the word is Win in cell G*** and the price in F*** is less than or equal to 10, do the calculation of the loss, -100 x F*** less 100; if above 10, put 0.

So, as you can see, there are only three possible answers, 95, 0 or the calculation of the loss.

If someone knows how to combine these correctly, it would be much appreciated.

Thanks in advance

 

[Michael M]

Maybe this

=IF(AND(G1256="LOST",F1256<=10),95,IF(AND(G1256="WIN",F1256<=10),-100*F1256+100,0))

 

[Fluff]

How about
=IF(F1256>10,0,IF(G1256="LOST",95,IF(G1256="WIN",-100*F1256+100,"")))

 

[honkin]

Maybe this

=IF(AND(G1256="LOST",F1256<=10),95,IF(AND(G1256="WIN",F1256<=10),-100*F1256+100,0))

My apologies for the delay, Michael. Yes, that works brilliantly

Thanks so much

regards

 

[Michael M]

Glad to help...