Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
haf wrote...
i've tried like this =IF((D5:H5;K5:N5)="+",COUNTBLANK(1:1)<3) but doesn't work .... (D5:H5;K5:N5)="+" is a syntax error. Do you mean OR(D5:H5="+",K5:N5="+") ? If so, you'd need to enter the formula =IF(OR(D5:H5="+",K5:N5="+"),COUNTBLANK(1:1)<3) as an array formula. Alternatively, you could use the following, longer non-array formula. =IF(COUNTIF(D5:H5,"+")+COUNTIF(K5:N5="+"),COUNTBLA NK(1:1)<3) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |