Use of "IF" and "AND" to print a message

[cfsosa]

Hi,

I’m trying to program this formula in cell A43 but doesn’t work. Basically I want to satisfy 3 conditions to print a message, that is:

1)E21 = something
2)E22 > something
3)E23> something

I’m using “IF” and “AND” and I get the following message:
“You’ve entered to many arguments for this function”

This is the formula I’m trying to create:

=IF(AND(E21=0.375,E23>4),"Member thickness is O.K!","Change Anchor diameter to comply with member thickness!",IF(AND(E21=0.5,E22>=2,E23>=4),"Member thickness is O.K!","Change Anchor diameter to comply with member thickness!",IF(AND(E21=0.5,E22>=3.25,E23>=6),"Member thickness is O.K!","Change Anchor diameter to comply with member thickness!",IF(AND(E21=0.625,E22>=3.125,E23>=5),"Member thickness is O.K!","Change Anchor diameter to comply with member thickness!",IF(AND(E21=0.625,E22>=4,E23>=6),"Member thickness is O.K!","Change Anchor diameter to comply with member thickness!",IF(AND(E21=0.75,E22>=3.75,E23>=6),"Member thickness is O.K!","Change Anchor diameter to comply with member thickness!",IF(AND(E21=0.75,E22>=4.75,E23>=8),"Member thickness is O.K!","Change Anchor diameter to comply with member thickness!")))))))

If somebody can give me an idea about what’s happening and give me some hints to make it work it would be greatly appreciated.

Thank you very much,
Cesar

[NBVC]

Perhaps combine all the AND's under an OR:

Please Login or Register  to view this content.

[cfsosa]

NBVC,

Thank you so much!!

Cesar