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  |