=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