If and OR

[BigB77]

Hello Everyone!
Ok, I am needing some help yet again. I am looking for a formula to do the following.
F1 is a changeable field. If F1 ends in 10 (310) and G19=odd number I need G22=0.
However, if F1 ends in 10 and G19=0 I need G22=1

Thank you
Brian

 

[philwojo]

I didn't know what you wanted to put if neither of those conditions existed so I just put "none" at the end, feel free to update that as necessary and try this in G22:

=IF(AND(RIGHT(F1,2)="10",ISODD(G19)),0,IF(AND(RIGHT(F1,2)="10",G19=0),1,"none"))