Link to home
Get AccessLog in
Avatar of Ernesto
ErnestoFlag for Mexico

asked on

Formula in excel

Want to achive 2 conditions if them are true then YES if one of them are not true then blank

SI((Q89>5.5 Y D92>5.5));"SI"
Avatar of yo_bee
yo_bee
Flag of United States of America image

This maybe what you want
=IF(AND(A1>5.5,B1>5.5),"SI","")

Open in new window

Avatar of Ernesto

ASKER

thats it
how to concatenate with

=IF(AND(A1>5.5,B1>5.5),TRUE,FALSE) or IF(AND(A1<2.4,B1<2.4),TRUE,FALSE)
is that posible?
regards
ASKER CERTIFIED SOLUTION
Avatar of yo_bee
yo_bee
Flag of United States of America image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of Ernesto

ASKER

Oh men!!!!
regards!