[malcolm]

I am using this formula to enter text into a column of cells of the source
worksheet and the corresponding column of cells in the destination worksheet;
=IF('End Bal'!B5="","",'End Bal'!B5). I enter this formula into cell B5 of
the destination worksheet and then copy down the column. I would like the
rule to be in effect for any text I type into the source worksheet except
when I enter the words NO SHOW, in this case I would like the destination
cell to remain blank. How do I accomplish this? I am using Excel 2007 but the
formula must be Excel 2003 compatible.
Thanks,
Malcolm

[FSt1]

hi
try this.....
=IF(OR('End Bal'!B5="",'End Bal'!B5="No Show"),"",'End Bal'!B5)

regards
FSt1


"Malcolm" wrote:

I am using this formula to enter text into a column of cells of the source
worksheet and the corresponding column of cells in the destination worksheet;
=IF('End Bal'!B5="","",'End Bal'!B5). I enter this formula into cell B5 of
the destination worksheet and then copy down the column. I would like the
rule to be in effect for any text I type into the source worksheet except
when I enter the words NO SHOW, in this case I would like the destination
cell to remain blank. How do I accomplish this? I am using Excel 2007 but the
formula must be Excel 2003 compatible.
Thanks,
Malcolm

[Gord Dibben]

=IF(OR('End Bal'!B5="",('End Bal'!B5="no show")),"",'End Bal'!B5)


Gord Dibben MS Excel MVP


On Sun, 30 May 2010 07:50:01 -0700, Malcolm
wrote:

I am using this formula to enter text into a column of cells of the source
worksheet and the corresponding column of cells in the destination worksheet;
=IF('End Bal'!B5="","",'End Bal'!B5). I enter this formula into cell B5 of
the destination worksheet and then copy down the column. I would like the
rule to be in effect for any text I type into the source worksheet except
when I enter the words NO SHOW, in this case I would like the destination
cell to remain blank. How do I accomplish this? I am using Excel 2007 but the
formula must be Excel 2003 compatible.
Thanks,
Malcolm

[T. Valko]

Another way to write the same formulas already suggested...

=IF(OR('End Bal'!B5={"","No Show"}),"",'End Bal'!B5)

--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
I am using this formula to enter text into a column of cells of the source
worksheet and the corresponding column of cells in the destination
worksheet;
=IF('End Bal'!B5="","",'End Bal'!B5). I enter this formula into cell B5 of
the destination worksheet and then copy down the column. I would like the
rule to be in effect for any text I type into the source worksheet except
when I enter the words NO SHOW, in this case I would like the destination
cell to remain blank. How do I accomplish this? I am using Excel 2007 but
the
formula must be Excel 2003 compatible.
Thanks,
Malcolm

[Gord Dibben]

Always tweaking<g

Shorter and more readable.

Thanks Biff


Gord

On Sun, 30 May 2010 12:21:34 -0400, "T. Valko"
wrote:

Another way to write the same formulas already suggested...

=IF(OR('End Bal'!B5={"","No Show"}),"",'End Bal'!B5)

[malcolm]

To the 3 Great Minds,
Thanks guys, they all worked. You all must have very strong necks to support
those giant brains. Could you modify the formula to only work in the
destination cell if the letter "S" is entered in the source cell? Again
thanks to all 3.
Best Regards,
Malcolm

"Gord Dibben" wrote:

Always tweaking<g

Shorter and more readable.

Thanks Biff


Gord

On Sun, 30 May 2010 12:21:34 -0400, "T. Valko"
wrote:

Another way to write the same formulas already suggested...

=IF(OR('End Bal'!B5={"","No Show"}),"",'End Bal'!B5)

.