Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |