Formula in excel

Ernesto
Ernesto used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
yo_beeDirector of Information Technology

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
Commented:
Here is just a basic true false output

=OR(AND(A2<2.4,B2<2.4),AND(A1>5.5,B1>5.5))

Open in new window


If you need actual values like SI you will need to use IF
=IF(OR(AND(A2<2.4,B2<2.4),AND(A1>5.5,B1>5.5)),"SI","")

Open in new window

Author

Commented:
Oh men!!!!
regards!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial