formula to select value from 8 cells
 

I have a spreadsheet that has 8 seperate fields that do a
calculation. The result of the calculation will either be a value
(ie. NUONT01) or 'FALSE'. Only one of the 8 fields will have a
value. All other fields will show FALSE. I need to display that one
value in field M8. What I am trying to do is look at all 8 fields and
the one that is not equal to 'false', show that value.

The field to display in is M8. Fields with the data a U8, AN8,
BA8, BN8, CA8, CN8, DA8, DN8.
I will be copying this formula down for the forty rows below. (M8 to
M47). I have tried "If(and" and "if(or" but cannot get past the first
3.

Mel

formula to select value from 8 cells
 

=IF(ISTEXT(U8),U8,"")&IF(ISTEXT(AN8),AN8,"")&IF(IS TEXT(BA8),BA8,"")...
--
David Biddulph

"Mel" wrote in message
...
I have a spreadsheet that has 8 seperate fields that do a
calculation. The result of the calculation will either be a value
(ie. NUONT01) or 'FALSE'. Only one of the 8 fields will have a
value. All other fields will show FALSE. I need to display that one
value in field M8. What I am trying to do is look at all 8 fields and
the one that is not equal to 'false', show that value.

The field to display in is M8. Fields with the data a U8, AN8,
BA8, BN8, CA8, CN8, DA8, DN8.
I will be copying this formula down for the forty rows below. (M8 to
M47). I have tried "If(and" and "if(or" but cannot get past the first
3.

Mel

formula to select value from 8 cells
 

On Nov 5, 10:39*am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=IF(ISTEXT(U8),U8,"")&IF(ISTEXT(AN8),AN8,"")&IF(IS TEXT(BA8),BA8,"")...
--
David Biddulph

"Mel" wrote in message

...



I have a spreadsheet that has 8 seperate fields that do a
calculation. *The result of the calculation will either be a value
(ie. NUONT01) or 'FALSE'. *Only one of the 8 fields will have a
value. *All other fields will show FALSE. *I need to display that one
value in field M8. *What I am trying to do is look at all 8 fields and
the one that is not equal to 'false', show that value.

The field to display in is M8. *Fields with the data a U8, AN8,
BA8, BN8, CA8, CN8, DA8, DN8.
I will be copying this formula down for the forty rows below. (M8 to
M47). I have tried "If(and" and "if(or" but cannot get past the first
3.

Mel- Hide quoted text -

- Show quoted text -

thanks David. Works perfectly. Seems so simple now.
thx again.
Mel