Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Up down arrow keys do not select cells if select locked cells unch | Excel Discussion (Misc queries) | |||
How do you select ALL cells that don't contain a formula | Excel Discussion (Misc queries) | |||
How to select Formula cells with red interior? | Excel Discussion (Misc queries) | |||
what allows me to select cells for use in a formula by using a mo. | Excel Worksheet Functions | |||
How do i select different cells to be use in a formula. | Excel Discussion (Misc queries) |