Please help - excel coding question

[spoilers]

Good morning all,

Is anyone able to help me with how to insert this logic into excel please?

I would like a cell to return 'BACK' if a cell value is less than say 5, but return 'LAY' if a cell value is above say 10.

Thanks very much in advance.

[Will Sharpe]

=IF(C2<D2;"BACK";IF(C2>F2;"LAY";"NO ACTION"))

Would do the trick if current odds is in C2 and Back threshold is=D2 and Lay threshold is=F2. Remove "NO ACTION" but keep the "" if you want it to go blank if price is between the thresholds

[Will Sharpe]

An improvement would be to use this:

=IF(AND(C2>D2;C2<E2);"BACK";IF(AND(C2>G2;C2<H2);"LAY";NO ACTION"

Where current odds is in C2 and Back minimum odds threshold is=D2 and Back maximum odds threshold is =E2. Lay minimum odds threshold is=G2 and Lay maximum odds threshold is =H2. Remove "NO ACTION" but keep the "" if you want it to go blank if price is between the thresholds

[spoilers]

Thank you very much guys. Much appreciated.