Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Evaluate Multiple Cells for any Value
If this has been covered previously I did not find it an searches. I have several cells that I need to evaluate. These cells are not side by side in columns but are on the same row. The cells will be blank except for one. After evaluation of all the cells, I need to return the value in the one cell that is not empty.
EX: A1=""; D1=""; M1=""; R1=May 5; Z1="". In cell AA1 I need to return only the value in the non-blank cell which is cell R1. How do I do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Evaluate Multiple Cells for any Value
Billy Daniel expressed precisely :
If this has been covered previously I did not find it an searches. I have several cells that I need to evaluate. These cells are not side by side in columns but are on the same row. The cells will be blank except for one. After evaluation of all the cells, I need to return the value in the one cell that is not empty. EX: A1=""; D1=""; M1=""; R1=May 5; Z1="". In cell AA1 I need to return only the value in the non-blank cell which is cell R1. How do I do this? One way... IF(LEN(A1),A1,IF(LEN(D1),D1,IF(LEN(M1),M1,IF(LEN(R 1),R1,Z1)))) -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Evaluate on multiple columns and return a value | Excel Worksheet Functions | |||
Multiple Conditions for IF statement to evaluate | Excel Worksheet Functions | |||
Function evaluate multiple cells and return 1st one w/a value | Excel Discussion (Misc queries) | |||
"OR" operator to evaluate multiple conditions | Excel Worksheet Functions | |||
Countif in VBA -- evaluate multiple criteria | Excel Programming |