Nov 13 2019 01:35 PM - edited Nov 13 2019 01:38 PM
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"
Nov 13 2019 01:41 PM
Nov 13 2019 01:44 PM - edited Nov 13 2019 01:49 PM
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",
Nov 13 2019 02:05 PM
You may use OR() for that, like
=IF( OR(A2="",A2=0,A2=1), "data quality issue",...)
Nov 13 2019 02:07 PM
Solutionor, perhaps
=IF( A2<=1, "data quality issue",...)
Blank cell will be considered as zero in this case
Nov 13 2019 02:07 PM
Solutionor, perhaps
=IF( A2<=1, "data quality issue",...)
Blank cell will be considered as zero in this case