Evaluate Multiple Cells for any Value

B

Billy Daniel

If this has been covered previously I did not find it an searches.
have several cells that I need to evaluate. These cells are not side b
side in columns but are on the same row. The cells will be blank excep
for one. After evaluation of all the cells, I need to return the valu
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 whic
is cell R1

How do I do this
 
G

GS

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(R1),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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top