We help IT Professionals succeed at work.

Formula in excel

91 Views
Last Modified: 2019-02-19
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"
Comment
Watch Question

yo_beeDirector of Information Technology
CERTIFIED EXPERT

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

Open in new window

Author

Commented:
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
Director of Information Technology
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Oh men!!!!
regards!