IF function with AND Function Issue

KuraiChikara

Board Regular
Joined
Nov 16, 2016
Messages
94
Office Version
2013
Platform
Windows
Hello,
I am trying to expand on the following formula:
=IF(B1="","","Hi")

Verbally it reads, "If B1 equals blank, put blank, other wise put HI."

What I'am trying to do is add another criteria for the blank portion such as:
"If B1 equals blank AND John, put blank, otherwise put hi."

I don't know how to introduce the additional criteria of John to return a blank result.
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,371
I think you meant
"If B1 equals blank OR John, put blank, otherwise put hi."

If so, try
=IF(OR(B1="",B1="John"),"","Hi")

M.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,350
Messages
5,486,349
Members
407,541
Latest member
Emilybuhman

This Week's Hot Topics

Top