Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help Needed!
Example
column a = blank column b = blank column c = blank column d = blank column e = will ALWAYS have a number so if there is a number in column e then say yes assuming all other cells are blank if there is a number in column e and any other column then say no this is what I need a formula based on... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help Needed!
Maybe
=IF(COUNT(A1:E1)1,"No","Yes") Mike "pivot table" wrote: Example column a = blank column b = blank column c = blank column d = blank column e = will ALWAYS have a number so if there is a number in column e then say yes assuming all other cells are blank if there is a number in column e and any other column then say no this is what I need a formula based on... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Formula needed | Excel Worksheet Functions | |||
Help needed with this formula | Excel Discussion (Misc queries) | |||
Formula needed | Excel Discussion (Misc queries) | |||
Formula needed | Excel Worksheet Functions |