SOLVED
Home

IF and ISBLANK formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1006945%22%20slang%3D%22en-US%22%3EIF%20and%20ISBLANK%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1006945%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3E%26nbsp%3BI'm%20trying%20to%20work%20out%20a%20formula%20but%20don't%20understand%20how%20to%20build%20it.%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIF(a2%26gt%3B1000%2C%22Senior%22%2C%22Junior%22)%20%26nbsp%3B%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Ebut%20if%20the%20cell%20is%20(blank%2C%200%2C%201)%20%3D%20%22data%20quality%20issue%22%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1006945%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1006958%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20and%20ISBLANK%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1006958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F48368%22%20target%3D%22_blank%22%3E%40Laura%20Backshell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF(A2%3D%22%22%2C%20%22data%20quality%20issue%22%2C%20IF(a2%26gt%3B1000%2C%22Senior%22%2C%22Junior%22)%20)%20%20%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1006961%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20and%20ISBLANK%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1006961%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bthanks%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eit%20doesnt%20show%200%20and%201%20as%20data%20quality%20issue%20though%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20i%20just%20make%20the%20first%20part%20multiple%20option%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(a2%3D%22%22%2C%220%22%2C%221%22%2C%20%22data%20quality%20issue%22%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1006988%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20and%20ISBLANK%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1006988%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F48368%22%20target%3D%22_blank%22%3E%40Laura%20Backshell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20OR()%20for%20that%2C%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF(%20OR(A2%3D%22%22%2CA2%3D0%2CA2%3D1)%2C%20%22data%20quality%20issue%22%2C...)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1006998%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20and%20ISBLANK%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1006998%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F48368%22%20target%3D%22_blank%22%3E%40Laura%20Backshell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eor%2C%20perhaps%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF(%20A2%26lt%3B%3D1%2C%20%22data%20quality%20issue%22%2C...)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EBlank%20cell%20will%20be%20considered%20as%20zero%20in%20this%20case%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1007639%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20and%20ISBLANK%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1007639%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bthanku%20%3CLI-EMOJI%20id%3D%22lia_monkey-face%22%20title%3D%22%3Amonkey_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1013448%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20and%20ISBLANK%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1013448%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F48368%22%20target%3D%22_blank%22%3E%40Laura%20Backshell%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Laura Backshell
Occasional Contributor

 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

@Laura Backshell 

It could be

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

 

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

@Laura Backshell 

You may use OR() for that, like

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

 

Solution

@Laura Backshell 

or, perhaps

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

Blank cell will be considered as zero in this case

@Sergei Baklan thanku

@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
Need FORMULA help please!!
marislav in Excel on
4 Replies