| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check if any values on row
Hi,
I am trying to have a formula on cell A1 for example that would look on cells D1:CT1 to see if there are any values different than 0 (in other words not empty or equal to 0). If there are any values different than 0, cell A1 would indicate "Row with data" if none, it would say "Empty row". Any help would be appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to check duplicated values | Excel Discussion (Misc queries) | |||
| Formula to Check Values between to variables | Excel Worksheet Functions | |||
| how can I check the value 1 cell against the values of entire row | Excel Discussion (Misc queries) | |||
| Q: check a range values | Excel Discussion (Misc queries) | |||
| How do I check for values in a list in an if statement? | Excel Discussion (Misc queries) | |||
Threaded Mode
