Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Then
How do I write a formula that will return an x if a range of cells have any
data? For example I would like A1 to return X, if any of the cells in B1 through P1 have any data in them. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Then
Enter this in A1
=IF(CountA(B1:P1)0,"X","") "Jim" wrote: How do I write a formula that will return an x if a range of cells have any data? For example I would like A1 to return X, if any of the cells in B1 through P1 have any data in them. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Then
Another possibility...
=LEFT("X",COUNTA(B1:P1)0) -- Rick (MVP - Excel) "Jim" wrote in message ... How do I write a formula that will return an x if a range of cells have any data? For example I would like A1 to return X, if any of the cells in B1 through P1 have any data in them. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|