Execl 2013 - IF Statements

mmj1
mmj1 used Ask the Experts™
on
II am working with an Excel 2013 document and trying to filter the list to provide me with the following:  The data in my two columns (N and O) have numeric values or they are blank.  I am trying to filter the list to show me the following:  If column "N" has a numeric value >1 AND column "O" has a numeric value >1 - then enter the words 'Has Both" in column "P".  I was thinking I might be able to use an IF statement but not quite sure how to set up the IF statement or should I be using a nested IF statement - or maybe some other function of Excel.  Your assistance is appreciated.  Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
KoenSDM Mobile
Commented:
use following function:

=If (and (N1;O1)>1;"Has Both"; "") in column P

you might need to replace the ; with , depending of the regional settings...

Author

Commented:
Thank you for your quick response.
I tried your formula and had an error - so I replaced all the semicolons with commas:

=IF(AND(N1,O1)>1,"Has Both","")

the result in column P shows:  #VALUE!

any further help is appreciated.
=IF(AND(N1>1,O1>1),"Has Both","")
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

or maybe better

=IF(AND(ISNUMBER(N1),ISNUMBER(O1),N1>1,O1>1),"Has Both","")
I think Ghinstek meant:

=if(and(n1>1, o1>1), "Has both","")

(with semi colon or comma as needed)

Saqib has also provided a solution which will take account of a text value rather than a number which can also cause #value errors
KoenSDM Mobile

Commented:
yes, my bad, too fast, too sloppy... sorry bout that.

Author

Commented:
Thank you all very much.
I did use the following from regmigrant:
=if(and(n1>1, o1>1), "Has both","") - and it worked great!

Thanks again to all.

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