Prev: Sumproduct formula help (possible Index????)
Next: V-Lookup variation query
From: Malcolm on 2 Jun 2010 09:27
Jacob, Hi,
My bad again. 'End Bal!'C10="D", 'End Bal'!B10 is an empty cell on the
source sheet. I want 'Close Bal'!C10="D" and 'Close Bal'B10=2 on the
destination sheet. Again my screwup led to to a formula based on my bad
information, my apologies.

Best Regards,
Malcolm

"Jacob Skaria" wrote:

> Hi Malcolm
>
> From your statement "I would like the number 2 and only 2 to be entered in
> the destination sheet." I thought the source sheet will have the value; but
> you need that to be returned only if the value is 2...
>
> If that is not the case; then try the below version
>
> =IF(OR('End Bal'!C10={"","C","B"}),'End Bal'!B10,
> IF(ISNUMBER('End Bal'!B10),IF('End Bal'!C10="S",'End al'!B10,
> IF('End Bal'!C10="D",2,"")),""))
>
> --
> Jacob (MVP - Excel)
>
>
> "Malcolm" wrote:
>
> > Jacob, Hi,
> > I entered your formula and it worked except for the last condition “D”. I
> > was not clear, but if the source sheet (End Bal) in cell C10 is “D” there is
> > no number in the source sheet (End Bal )C10. That is why I wanted to add the
> > 2 to the destination sheet B10. So, does the “'End Bal'!B10=2) refer to the
> > source sheet? If so, there is no number there. If I am unclear please let me
> > know.
> >
> > =IF(OR('End Bal'!C10={"","C","B"}),'End Bal'!B10,IF(ISNUMBER('End
> > Bal'!B10),IF('End Bal'!C10="S",'End Bal'!B10,IF(AND('End Bal'!C10="D",'End
> > Bal'!B10=2),2,"")),""))
> >
> > Regards,
> > Malcolm
> >
> >
> > "Jacob Skaria" wrote:
> >
> > > Try
> > >
> > > =IF(OR(C10={"","C","B"}),B10,IF(ISNUMBER(B10),IF(C10="S",B10,
> > > IF(AND(C10="D",B10=2),2,"")),""))
> > >
> > > --
> > > Jacob (MVP - Excel)
> > >
> > >
> > > "Malcolm" wrote:
> > >
> > > > I'm using this formula;
> > > > =IF(OR('Source Sheet'!C10={“”,”C”, “B”}),'Source Sheet'!B10).
> > > > This allows what I enter into the source sheet to also enter into the
> > > > destination sheet unless, “C” or “B” are present and then nothing is entered
> > > > into the destination sheet. This only leaves two conditions that would allow
> > > > data entered into the source sheet to appear in the destination sheet. These
> > > > conditions are “S” and “D”. If “S” I would like to have any number entered in
> > > > the source sheet to appear in the destination sheet, but if the “D” condition
> > > > is entered in the source sheet, I would like the number 2 and only 2 to be
> > > > entered in the destination sheet. So, if I have not confused this too much,
> > > > my question is; is it possible to keep the initial two false conditions; “C”
> > > > and “B” in the formula and add the two true conditions “S” and “D”. I hope
> > > > that my explanation is not too confusing. I don't have a good record of being
> > > > either clear or concise.
> > > > Thank you,
> > > > Malcolm
> > > >
First  |  Prev  | 
Pages: 1 2
Prev: Sumproduct formula help (possible Index????)
Next: V-Lookup variation query