IF and ISBLANK formula

[Laura Backshell]

 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" 

[#2]

@Laura Backshell 

It could be

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

[#3]

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",

[#4]

@Laura Backshell 

You may use OR() for that, like

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

[#5 · Accepted solution]

@Laura Backshell 

or, perhaps

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

Blank cell will be considered as zero in this case

[#6]

@Sergei Baklan thanku :o)

[#7]

@Laura Backshell , you are welcome