trigger L9 query in excel

[sandycove]

Just encountered a problem which I never saw before. A simple "if" statement in cell L9 creates an error message in the status cell yet there is no problem if I use the single command "back". The error occurs both Pre-off and In-Play on the horse racing market. The odds and stake cells present no problems using "if" statements. Any help would be much appreciated.

[ODPaul82]

If you put the formula that you've got in L9 with the IF statement would be a hell of a lot easier to diagnose
It may well be one part of your statement triggers fine but it encounters the error in the other side of the operand.

[sandycove]

Thank you, The command in cell L9 is simple :
If( $G$1="In-Play,","back,"""). However, as stated earlier, the command "back" on it's own presents no problem.
The other formulae work fine without error messages when using the "back" command.

[jamesg46]

https://youtu.be/llxmSFJAmIY

[Trader724]

=IF($G$1="In-Play"; "BACK"; "") Does this work?

[MarketTrader]

Are you sure your commas are in the right place? The formula you posted definitely has an error in it.

Try this:

Code: Select all

=IF( $G$1="In-Play","BACK","")

[sandycove]

Thank you all for your replies. Sorry about typing mistake in my last post re the misplaced comma !
I will try your suggested code later tonight.

[sandycove]

Got it working again so thanks to all who responded.