Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,514
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Evaluate on multiple columns and return a value CynthiaF Excel Worksheet Functions 5 October 27th 08 03:06 PM
Multiple Conditions for IF statement to evaluate Bees*Stars Excel Worksheet Functions 1 March 13th 07 11:20 PM
Function evaluate multiple cells and return 1st one w/a value Dan Shoemaker Excel Discussion (Misc queries) 1 August 27th 06 02:46 AM
"OR" operator to evaluate multiple conditions anand Excel Worksheet Functions 1 May 23rd 05 08:49 PM
Countif in VBA -- evaluate multiple criteria Scott P Excel Programming 11 June 11th 04 02:07 PM


All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"