(Msg. 1) Posted: Wed Nov 04, 2009 2:24 pm
Post subject: nested function to select value from 8 options Archived from groups: microsoft>public>excel>misc (more info?)
I have a spreadsheet that has 8 seperate tables that do a
calculation. If the input option matches one of the 8, a value will
be displayed, if not, 'False' will be displayed. What I am trying to
do is look at all 8 fields and the one that is not equal to 'false',
show that value.
field to display in is M8. Fields with the data are: 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.
(Msg. 2) Posted: Wed Nov 04, 2009 2:31 pm
Post subject: Re: nested function to select value from 8 options [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Nov 4, 10:24 pm, Mel <mel.pilg... DeleteThis @agr.gc.ca> wrote:
> I have a spreadsheet that has 8 seperate tables that do a
> calculation. If the input option matches one of the 8, a value will
> be displayed, if not, 'False' will be displayed. What I am trying to
> do is look at all 8 fields and the one that is not equal to 'false',
> show that value.
>
> field to display in is M8. Fields with the data are: 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.
>
> I know there has to be an easier way.
> thx
>
> Mel
Hello Mel,
I'm not really clear what you want to do. What value is in M8, can you
give an example. Are you looking for a match with one of those 8
cells. If M8 = BA8 for instance then what value would you like to
return?
(Msg. 3) Posted: Wed Nov 04, 2009 2:34 pm
Post subject: Re: nested function to select value from 8 options [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Nov 4, 4:31 pm, barry houdini <barry.houd... RemoveThis @virgin.net> wrote:
> On Nov 4, 10:24 pm, Mel <mel.pilg... RemoveThis @agr.gc.ca> wrote:
>
>
>
>
>
> > I have a spreadsheet that has 8 seperate tables that do a
> > calculation. If the input option matches one of the 8, a value will
> > be displayed, if not, 'False' will be displayed. What I am trying to
> > do is look at all 8 fields and the one that is not equal to 'false',
> > show that value.
>
> > field to display in is M8. Fields with the data are: 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.
>
> > I know there has to be an easier way.
> > thx
>
> > Mel
>
> Hello Mel,
>
> I'm not really clear what you want to do. What value is in M8, can you
> give an example. Are you looking for a match with one of those 8
> cells. If M8 = BA8 for instance then what value would you like to
> return?
>
> regards, barry- Hide quoted text -
>
> - Show quoted text -
The info in M8 will be from one of the 8 fields. One field will have
a value such as NUONT01 and the rest will have 'false'. Only one will
have a value, the rest will have false listed.
(Msg. 4) Posted: Wed Nov 04, 2009 6:43 pm
Post subject: RE: nested function to select value from 8 options [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If the values are "False" (as in the logical False condition) then this will
work:
> I have a spreadsheet that has 8 seperate tables that do a
> calculation. If the input option matches one of the 8, a value will
> be displayed, if not, 'False' will be displayed. What I am trying to
> do is look at all 8 fields and the one that is not equal to 'false',
> show that value.
>
> field to display in is M8. Fields with the data are: 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.
>
> I know there has to be an easier way.
> thx
>
> Mel
> .
>
(Msg. 5) Posted: Thu Nov 05, 2009 6:49 am
Post subject: Re: nested function to select value from 8 options [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Nov 4, 8:43 pm, dhstein <dhst....TakeThisOut@discussions.microsoft.com> wrote:
> If the values are "False" (as in the logical False condition) then this will
> work:
>
> =IF(U8,U8,IF(AN8,AN8,IF(BA8,BA8,IF(BN8,BN8,IF(CA8,CA8,IF(CN8,CN8,IF(DA8,DA8,IF(DN8,DN8,"No Matches"))))))))
>
>
>
> "Mel" wrote:
> > I have a spreadsheet that has 8 seperate tables that do a
> > calculation. If the input option matches one of the 8, a value will
> > be displayed, if not, 'False' will be displayed. What I am trying to
> > do is look at all 8 fields and the one that is not equal to 'false',
> > show that value.
>
> > field to display in is M8. Fields with the data are: 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.
>
> > I know there has to be an easier way.
> > thx
>
> > Mel
> > .- Hide quoted text -
>
> - Show quoted text -
no, this will not work. in the 8 fields that I have listed, there
will only be one that had data ie (NUONT2) and all the other fields
will be displaying 'FALSE'. I need to be able to only display the
field with the data and not 'false'.
thx
Mel
(Msg. 6) Posted: Sat Nov 07, 2009 11:11 am
Post subject: Re: nested function to select value from 8 options [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Nov 5, 2:49 pm, Mel <mel.pilg....DeleteThis@agr.gc.ca> wrote:
> On Nov 4, 8:43 pm, dhstein <dhst....DeleteThis@discussions.microsoft.com> wrote:
>
>
>
>
>
> > If the values are "False" (as in the logical False condition) then this will
> > work:
>
> > =IF(U8,U8,IF(AN8,AN8,IF(BA8,BA8,IF(BN8,BN8,IF(CA8,CA8,IF(CN8,CN8,IF(DA8,DA8,IF(DN8,DN8,"No Matches"))))))))
>
> > "Mel" wrote:
> > > I have a spreadsheet that has 8 seperate tables that do a
> > > calculation. If the input option matches one of the 8, a value will
> > > be displayed, if not, 'False' will be displayed. What I am trying to
> > > do is look at all 8 fields and the one that is not equal to 'false',
> > > show that value.
>
> > > field to display in is M8. Fields with the data are: 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.
>
> > > I know there has to be an easier way.
> > > thx
>
> > > Mel
> > > .- Hide quoted text -
>
> > - Show quoted text -
>
> no, this will not work. in the 8 fields that I have listed, there
> will only be one that had data ie (NUONT2) and all the other fields
> will be displaying 'FALSE'. I need to be able to only display the
> field with the data and not 'false'.
> thx
> Mel- Hide quoted text -
>
> - Show quoted text -
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office