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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

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,099,684
Messages
5,470,114
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top