New To Excel Formulas..problems with "or"

[ianhamilton]

Hi Guys,

I use a programme that connects with Excel which enables me to trade on football matches using Excel formulas.

I currently have a formula that will settle my bets when i hit the profit i want.

The help i require is can i do a formula which is similar to the following:

=IF(D14>50, "GREEN") or IF(D14<-25, "GREEN")

i keep getting an error! Also, can you use minus numbers and if so how?? thanks in advance!!

Ian

[davesexcel]

Try this
=IF(OR(D14>50,D14<-25),"GREEN","")