| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IS BLANK checking 2 Cells
I have a statement -
to check if both cells are blank then I need to populate with Not Assigned, if anyone of the cells is not blank then I need it to populate with Assigned. Here is the formula but it is not working =IF(OR(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned") if one of the cells is not blank it popluates with NOT assigned but I want it to show Assigned. Thanks -- mmk |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IS BLANK checking 2 Cells
Hi,
Change OR to AND =IF(AND(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned") Mike "MKuria" wrote: I have a statement - to check if both cells are blank then I need to populate with Not Assigned, if anyone of the cells is not blank then I need it to populate with Assigned. Here is the formula but it is not working =IF(OR(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned") if one of the cells is not blank it popluates with NOT assigned but I want it to show Assigned. Thanks -- mmk |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IS BLANK checking 2 Cells
Alternatively, you could use the following formula:
=IF(COUNTBLANK(your range)=2,"Not Assigned","Assigned") Hope this helps? "Mike H" wrote in message ... Hi, Change OR to AND =IF(AND(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned") Mike "MKuria" wrote: I have a statement - to check if both cells are blank then I need to populate with Not Assigned, if anyone of the cells is not blank then I need it to populate with Assigned. Here is the formula but it is not working =IF(OR(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned") if one of the cells is not blank it popluates with NOT assigned but I want it to show Assigned. Thanks -- mmk |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IS BLANK checking 2 Cells
The formula =IF(OR(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned")
is working exactly how it should: if ANY ONE of the cell is blank then you get "Not Assigned" The formula =IF(AND(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned") will give "Not assigned" only when BOTH cells are blank So will =IF(COUNTA(AD2, AE2),"Assigned", "Not Assigned") best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "MKuria" wrote in message ... I have a statement - to check if both cells are blank then I need to populate with Not Assigned, if anyone of the cells is not blank then I need it to populate with Assigned. Here is the formula but it is not working =IF(OR(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned") if one of the cells is not blank it popluates with NOT assigned but I want it to show Assigned. Thanks -- mmk |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IS BLANK checking 2 Cells
=IF(OR(NOT(ISBLANK(A1)),NOT(ISBLANK(B1))),"Assigne d","Unassigned")
"MKuria" wrote: I have a statement - to check if both cells are blank then I need to populate with Not Assigned, if anyone of the cells is not blank then I need it to populate with Assigned. Here is the formula but it is not working =IF(OR(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned") if one of the cells is not blank it popluates with NOT assigned but I want it to show Assigned. Thanks -- mmk |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IS BLANK checking 2 Cells
Hi,
Either =IF(AND(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned") or shorter: =IF(AND(AD2="",AE2=""),"Not Assigned", "Assigned") or shorter still =IF(AND(AD2="",AE2=""),"Not ","")&"Assigned" or even shorter: =IF(COUNTA(AD2:AE2),,"Not ")&"Assigned" -- If this helps, please click the Yes button. Cheers, Shane Devenshire "MKuria" wrote: I have a statement - to check if both cells are blank then I need to populate with Not Assigned, if anyone of the cells is not blank then I need it to populate with Assigned. Here is the formula but it is not working =IF(OR(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned") if one of the cells is not blank it popluates with NOT assigned but I want it to show Assigned. Thanks -- mmk |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IS BLANK checking 2 Cells
A little shorter yet...
=IF(AD2&AE2="","Not ",)&"Assigned" -- Rick (MVP - Excel) "Shane Devenshire" wrote in message ... Hi, Either =IF(AND(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned") or shorter: =IF(AND(AD2="",AE2=""),"Not Assigned", "Assigned") or shorter still =IF(AND(AD2="",AE2=""),"Not ","")&"Assigned" or even shorter: =IF(COUNTA(AD2:AE2),,"Not ")&"Assigned" -- If this helps, please click the Yes button. Cheers, Shane Devenshire "MKuria" wrote: I have a statement - to check if both cells are blank then I need to populate with Not Assigned, if anyone of the cells is not blank then I need it to populate with Assigned. Here is the formula but it is not working =IF(OR(ISBLANK(AD2),ISBLANK(AE2)),"Not Assigned", "Assigned") if one of the cells is not blank it popluates with NOT assigned but I want it to show Assigned. Thanks -- mmk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking for blank cells when using vlookup | Excel Worksheet Functions | |||
| Checking cells are = and return a value | Excel Discussion (Misc queries) | |||
| Checking the Cells in Sheet1 with Cells in Sheet2 and replace | Excel Worksheet Functions | |||
| Checking Blank Cells | Excel Worksheet Functions | |||
| Checking that any cells are null | Excel Worksheet Functions | |||
Hybrid Mode
