Forum Discussion
Solved
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"
or, perhaps
=IF( A2<=1, "data quality issue",...)Blank cell will be considered as zero in this case
hi SergeiBaklan 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",
or, perhaps
=IF( A2<=1, "data quality issue",...)Blank cell will be considered as zero in this case
SergeiBaklan thanku :o)
LauraDaisy , you are welcome