Prev: How to find a value with multi-column, multi-record list
Next: CONVERT function for Excel 2003
From: Malcolm on 30 May 2010 10:50
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

From: FSt1 on 30 May 2010 11:46
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
>
From: Gord Dibben on 30 May 2010 11:48
=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
<Malcolm(a)discussions.microsoft.com> 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

From: T. Valko on 30 May 2010 12:21
Another way to write the same formulas already suggested...

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

--
Biff
Microsoft Excel MVP


"Malcolm" <Malcolm(a)discussions.microsoft.com> wrote in message
news:22114C3D-F656-471D-9D7D-1DE5ECA487B6(a)microsoft.com...
>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
>


From: Gord Dibben on 30 May 2010 12:39
Always tweaking<g>

Shorter and more readable.

Thanks Biff


Gord

On Sun, 30 May 2010 12:21:34 -0400, "T. Valko" <biffinpitt(a)comcast.net>
wrote:

>Another way to write the same formulas already suggested...
>
>=IF(OR('End Bal'!B5={"","No Show"}),"",'End Bal'!B5)

 |  Next  |  Last
Pages: 1 2
Prev: How to find a value with multi-column, multi-record list
Next: CONVERT function for Excel 2003