About
Pricing
Community
Teams
Start Free Trial
Log in
Ernesto
asked on
2/19/2019
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 Excel
Microsoft Office
4
1
Last Comment
Ernesto
8/22/2022 - Mon
yo_bee
2/19/2019
This maybe what you want
=IF(AND(A1>5.5,B1>5.5),"SI","")
Select all
Open in new window
Ernesto
2/19/2019
ASKER
thats it
how to concatenate with
=IF(AND(A1>5.5,B1>5.5),TRU
E,FALSE) or IF(AND(A1<2.4,B1<2.4),TRUE
,FALSE)
is that posible?
regards
ASKER CERTIFIED SOLUTION
yo_bee
2/19/2019
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
2/19/2019
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
Open in new window