Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checking cells for 2 conditions
Hi,
I hope someone can help me with this. I have four cells A1:A4. If all four cells contain data or are blank then thats okay. But if 1, 2 or 3 cells contain data then I want a warning that all cells must be blank or contain data. Thanks Mary |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checking cells for 2 conditions
Try this:
=IF(AND(COUNTA(A1:A4)0,COUNTA(A1:A4)<4),"Incorrec t entries","") Change the wording of "Incorrect entries" to whatever message you would like. Hope this helps. Pete On Jul 21, 2:07 am, "Mary Lancaster" wrote: Hi, I hope someone can help me with this. I have four cells A1:A4. If all four cells contain data or are blank then thats okay. But if 1, 2 or 3 cells contain data then I want a warning that all cells must be blank or contain data. Thanks Mary |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checking cells for 2 conditions
One way.
You can use a formula like this in, say, B4: =IF(OR(COUNTA(A1:A4)=4,COUNTBLANK(A1:A4)=4),"","Al l 4 cells must be either filled or left empty") Maybe give it a bold red font. -- Biff Microsoft Excel MVP "Mary Lancaster" wrote in message ... Hi, I hope someone can help me with this. I have four cells A1:A4. If all four cells contain data or are blank then thats okay. But if 1, 2 or 3 cells contain data then I want a warning that all cells must be blank or contain data. Thanks Mary |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checking cells for 2 conditions
"Mary Lancaster" wrote...
I hope someone can help me with this. I have four cells A1:A4. If all four cells contain data or are blank then thats okay. But if 1, 2 or 3 cells contain data then I want a warning that all cells must be blank or contain data. More alternatives, =IF(ABS(COUNTA(A1:A4)-2)<2,"A1:A4 partially filled","") =IF(AND(COUNTIF(A1:A4,{"=";"<"})<4),"A1:A4 partially filled","") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
Checking the Cells in Sheet1 with Cells in Sheet2 and replace | Excel Worksheet Functions | |||
checking two conditions | Excel Discussion (Misc queries) | |||
Checking if 2 of 3 conditions are met... | Excel Discussion (Misc queries) | |||
Checking that any cells are null | Excel Worksheet Functions |