Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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.misc
|
|||
|
|||
![]()
Don't multi post it's irritating to those who give their time freely to
answer questions only to find the question answered in another group "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... |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Use in F1 and copy down
=IF(AND(A1="",B1="",C1="",D1=""),"Yes","No") This does not check for E1 since you are sure it will always have a value. You can add that also =IF(AND(A1="",B1="",C1="",D1="",E1<""),"Yes","No" ) "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... |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Please do not double post!
-- ** John C ** "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) | |||
if formula needed | Excel Discussion (Misc queries) | |||
IF/AND/OR FORMULA HELP NEEDED | Excel Discussion (Misc queries) | |||
Formula help needed | Excel Discussion (Misc queries) | |||
Help! Formula needed. | Excel Discussion (Misc queries) |