Avatar of Ernesto
Ernesto
Flag 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"
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Ernesto

8/22/2022 - Mon
yo_bee

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

Open in new window

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
yo_bee

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Ernesto

ASKER
Oh men!!!!
regards!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck