I'm trying to create a link between worksheets that chooses between two
values in two different cells, and chooses one of them. What function, if
any, could I use?
I'm trying to create a link between worksheets that chooses between two
values in two different cells, and chooses one of them. What function, if
any, could I use?
Without knowing what your selection criteria is, it is difficult to answer,
but for example if you are looking for a maximum something like
=MAX(Sheet2!A1,Sheet3!A1)
would work
"Gailwdz" wrote:
> I'm trying to create a link between worksheets that chooses between two
> values in two different cells, and chooses one of them. What function, if
> any, could I use?
>
Sounds like IF
=IF(Sheet1!A1="A", A1,B1)
--
HTH
Bob Phillips
"Gailwdz" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to create a link between worksheets that chooses between two
> values in two different cells, and chooses one of them. What function, if
> any, could I use?
>
Thank you. It did help, but I think I need a nested formula. My data looks a
little like this:
US Received Competent Moderated Verified
114943 R C M V
R C M
What I'm trying to do is determine at which stage the US is at. Example -
the unit standard has been received and marked competent, but has not been
verified yet - then the formula must determine that the cell marked V is
empty, and then determine whether the cell marked M is empty or not, and so
on.
The formula should also check the columns from right to left, to see at what
stage the unit standard is at, at present.
I hope that's not as confusing to you as it sounds to me!
"Bob Phillips" wrote:
> Sounds like IF
>
> =IF(Sheet1!A1="A", A1,B1)
>
> --
> HTH
>
> Bob Phillips
>
> "Gailwdz" <[email protected]> wrote in message
> news:[email protected]...
> > I'm trying to create a link between worksheets that chooses between two
> > values in two different cells, and chooses one of them. What function, if
> > any, could I use?
> >
>
>
>
try
=if(verified="V","V",if(moderated="M","M",if(competent="C","C",if(received="R","R",""))))
where verified is the appropriate cell in the "Verified"column, etc.
"Gailwdz" wrote:
> Thank you. It did help, but I think I need a nested formula. My data looks a
> little like this:
>
> US Received Competent Moderated Verified
> 114943 R C M V
> R C M
>
> What I'm trying to do is determine at which stage the US is at. Example -
> the unit standard has been received and marked competent, but has not been
> verified yet - then the formula must determine that the cell marked V is
> empty, and then determine whether the cell marked M is empty or not, and so
> on.
>
> The formula should also check the columns from right to left, to see at what
> stage the unit standard is at, at present.
>
> I hope that's not as confusing to you as it sounds to me!
>
>
> "Bob Phillips" wrote:
>
> > Sounds like IF
> >
> > =IF(Sheet1!A1="A", A1,B1)
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "Gailwdz" <[email protected]> wrote in message
> > news:[email protected]...
> > > I'm trying to create a link between worksheets that chooses between two
> > > values in two different cells, and chooses one of them. What function, if
> > > any, could I use?
> > >
> >
> >
> >
Thanks very much.
"bj" wrote:
> try
> =if(verified="V","V",if(moderated="M","M",if(competent="C","C",if(received="R","R",""))))
> where verified is the appropriate cell in the "Verified"column, etc.
>
> "Gailwdz" wrote:
>
> > Thank you. It did help, but I think I need a nested formula. My data looks a
> > little like this:
> >
> > US Received Competent Moderated Verified
> > 114943 R C M V
> > R C M
> >
> > What I'm trying to do is determine at which stage the US is at. Example -
> > the unit standard has been received and marked competent, but has not been
> > verified yet - then the formula must determine that the cell marked V is
> > empty, and then determine whether the cell marked M is empty or not, and so
> > on.
> >
> > The formula should also check the columns from right to left, to see at what
> > stage the unit standard is at, at present.
> >
> > I hope that's not as confusing to you as it sounds to me!
> >
> >
> > "Bob Phillips" wrote:
> >
> > > Sounds like IF
> > >
> > > =IF(Sheet1!A1="A", A1,B1)
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > "Gailwdz" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > I'm trying to create a link between worksheets that chooses between two
> > > > values in two different cells, and chooses one of them. What function, if
> > > > any, could I use?
> > > >
> > >
> > >
> > >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks