Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to connect the Excel function (IF) with another function (AND) In Excel 2013 ?

Excel

Microsoft Excel Microsoft Office Computer Skills
user-image
Question added by Mohamed A. Salam Salama , Account Payable Supervisor , Park Inn by Radisson
Date Posted: 2017/04/04
Upvote (0) Views (11) Followers (5) Answers (5) Report Question
Write an Answer
Register now or log in to answer.
RAHEL KORBU
by RAHEL KORBU , primily school , nafyad scool

to make statically organization and to be comfortable

Pramod Karna
by Pramod Karna , Assistant Manager , TVS Supply Chain Solutions Limited

If Syntax = if(And(A1=x,B1=y),True Value,False Value)

 

This is how IF and AND functions are linked

OMAR AL-TAMIMI

Syntax for IF function = IF(Logical test, if the test is true then this value, if false than this value). 

You can use the AND function in the logical test.

Firas Shahadi
by Firas Shahadi , Training And Development Director , Muhayal Assir National Hospital

Hi Mr. Mohamed:

thank you for this question.

we can do that as below

=if(and(a1=9,b1=8,c1=7),this is the true part, this is the false past)

but with AND all the conditions must me true to execute the true part of IF().

 

Great question.

Thank you

Ashish Ranka
by Ashish Ranka , VP - Accounts , Adarsh Developers

We can use "IF" and "AND" function when we want to check more than one condition.

Simple "IF" function states whether the statement is True or False.

Syntax for IF function = IF(Logical test,if the test is true than this value,if false than this value)

 

Syntax for "IF" and "AND" function together = IF(AND(first condition, second condition, .....etc),if all conditions are true than this value, if any condition is false than this value).

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help