How to add 3 arguments to a rule

[Toota]

Hi there,
Hoping someone will be able to add these arguments to my Rule.
The commands i will be using are "lay" "Green" "Close_Trade"

So Rule is IF AK9>0 "LAY" and when AM9>0 "GREEN" or D10>2 "CLOSE_TRADE"

it is probably very simple and hopefully someone can Help?
Thanking You Brendan

 

[mrshl9898]

=IF(AK9>0,"LAY",IF(AM9>0,"GREEN",IF(D10>2,"CLOSE_TRADE")))

 

[Toota]

Thankyou so much mrshl9898 you have made my day

 

[Toota]

Thankyou so much mrshl9898 you have made my day

mrshl9898 i may not have explained myself the best
So Rule is IF AK9>0 "LAY" then when(only when ak9>0 do we move onto)or AM9>0 "GREEN" or D10>2 "CLOSE_TRADE"
Thankyou so much if you could edit your answer =IF(AK9>0,"LAY",IF(AM9>0,"GREEN",IF(D10>2,"CLOSE_TRADE")))

 

[mrshl9898]

Sounds like that is what we have?

If AK9>0 then LAY is returned, if not then if AM9>0 then GREEN is returned, if not then if D10>2 then CLOSE TRADE, if none are met then you should see FALSE

If you're expecting a different result then a screenshot may be helpful

 

[Toota]

Ok sorry AK9>0 then LAY is returned-correct ONLY then do we AM9>0 "GREEN",or D10>2"close trade"

So if AK is not greater than 0 then nothing else can happen
Love how quick you are

 

[jtakw]

Hi,

I'm thinking may be this is what you mean:

=IF(AK9>0,IF(AM9>0,"GREEN",IF(D10>2,"CLOSE TRADE","LAY")),"")

 

[Toota]

Thank you jtakw i will try it Thanks

 

[Toota]

Thanks all good

 

[jtakw]

You're welcome, thanks for letting us know.

I do believe you're supposed to mark the post that gave you the correct answer as "answer"...Unless you answered your own question.