• 513K Members
• 2,662 Online
• 611K Conversations
SOLVED

## IF and ISBLANK formula

Highlighted
Occasional Contributor

# IF and ISBLANK formula

I'm trying to work out a formula but don't understand how to build it.

=IF(a2>1000,"Senior","Junior")

but if the cell is (blank, 0, 1) = "data quality issue"

6 Replies

# Re: IF and ISBLANK formula

It could be

``=IF(A2="", "data quality issue", IF(a2>1000,"Senior","Junior") )  ``

# Re: IF and ISBLANK formula

hi @Sergei Baklan thanks

it doesnt show 0 and 1 as data quality issue though

can i just make the first part multiple option?

=IF(a2="","0","1", "data quality issue",

# Re: IF and ISBLANK formula

You may use OR() for that, like

``=IF( OR(A2="",A2=0,A2=1), "data quality issue",...)``

Solution

# Re: IF and ISBLANK formula

or, perhaps

``=IF( A2<=1, "data quality issue",...)``

Blank cell will be considered as zero in this case

# Re: IF and ISBLANK formula

@Sergei Baklan thanku

# Re: IF and ISBLANK formula

@Laura Backshell , you are welcome

Related Conversations
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies