Simple excel formula help

[Toota]

Hi Guys,
I have a formula that is not working
=IF(AG10=1,IF(OR("C4">8,H9>3.4,"H4"<8),"LAY"),"")
Ok so what i am after please is if AG10=1 and C4>8,H9>3.4,H4<8 Then instruction is to LAY

I know i have a little mistake in there but cannot find it
Help would be appreciated
Thanks

 

[Zot]

Not sure what you really want. Something like this?
=IF(AND(AG10=1,OR("C4">8,H9>3.4,"H4"<8)),"LAY","")

 

[Toota]

Not sure what you really want. Something like this?
=IF(AND(AG10=1,OR("C4">8,H9>3.4,"H4"<8)),"LAY","")

ill let you know shortly thanks

=IF(AND(AG10=1,OR("C4">8,H9>3.4,"H4"<8)),"LAY","")

tHANKS VERY GOOD

 

[Peter_SSs]

@Toota
I'm not exactly sure what you are wanting either but I don't believe that it is the formula suggested in post #2. If C4 and H4 are referring to cell values which it sounds like from your written description, then they should not have quote marks around them in the formula, otherwise they will be treated as literal text.
For example "C4">8 will always be true no matter what is in cell C4
On the other hand C4>8 could sometimes be true and sometimes false, depending on what is in cell C4

 

[Zot]

@Toota
I'm not exactly sure what you are wanting either but I don't believe that it is the formula suggested in post #2. If C4 and H4 are referring to cell values which it sounds like from your written description, then they should not have quote marks around them in the formula, otherwise they will be treated as literal text.
For example "C4">8 will always be true no matter what is in cell C4
On the other hand C4>8 could sometimes be true and sometimes false, depending on what is in cell C4

Good catch. I wasn't paying attention to those double quotes