Help with rules and commands

[Toota]

Hi there,
I have been lucky enough to get some answers previously and now have another one
A rule for my spreadsheet
Rule can only start when AF8<105 and J3<5but >3
Ok then we have commands LAY and GREEN
AK9>0 LAY when and if that happens then "IF AG9 is 10% < AI9 then GREEN" or "H4=0 GREEN"

Thanks i really love the way everyone helps one another.

 

[jtakw]

Hi,

Try this:

=IF(AND(AF8<105,J3>3,J3<5),IF(AK9>0,IF(OR(AG9<AI9*0.9,H4=0),"GREEN","LAY"),""))

 

[Toota]

Hi,

Try this:

=IF(AND(AF8<105,J3>3,J3<5),IF(AK9>0,IF(OR(AG9<AI9*0.9,H4=0),"GREEN","LAY"),""))

Thankyou looks intersting love it

 

[jtakw]

IF AG9 is 10% < AI9

I'm a bit unclear regarding this part, so you may need to change the < to <= like below:

=IF(AND(AF8<105,J3>3,J3<5),IF(AK9>0,IF(OR(AG9<=AI9*0.9,H4=0),"GREEN","LAY"),""))

 

[Toota]

Thanks ill try it

 

[Toota]

Jtakw i am getting error in status cell?

 

[jtakw]

What is the error?
You may have numbers in cells that are actually Text.

 

[Toota]

Maybe my typing mistake ill get back to you tomorrow thanks so much

 

[Toota]

Thankyou looks intersting love it

All good just changed lay and green around

 

[jtakw]

"IF AG9 is 10% < AI9 then GREEN" or "H4=0 GREEN"

That's not what your description says.

And I see you marked your own post as "answer" again.