very simple logical

nowfal · #1 07-29-2005, 03:31 PM

Hi,
very simple question if the cell N6 having telephone number then M6 to show "TEL", and if N6 is blank then M6 also to be blank.
regards
selma d/o. nowfal

swatsp0p · #2 07-29-2005, 03:39 PM

enter this in M6:

=IF(N6<>"","TEL","")

Good Luck

Bruce

nowfal · #3 07-29-2005, 04:04 PM

Hi Bruce,
That is not correct. thanks for quick response.
by
selma

nowfal · #4 07-29-2005, 04:06 PM

Sorry Bruce
My mistake, its working . thanks
regards

#5 07-29-2005, 05:05 PM

You can't have a formula in a cell and have it be blank. You can have
the formula return a null string ("") to appear blank.

If any entry in N6 is a telephone number, then

M6: =IF(ISBLANK(N6),"","TEL")

Otherwise, you need to specify how XL should determine if the entry is a
telephone number

In article <nowfal.1sy66q_1122667519.7803@excelforum-nospam.com>,
nowfal <nowfal.1sy66q_1122667519.7803@excelforum-nospam.com> wrote:

> very simple question if the cell N6 having telephone number then M6
> to show "TEL", and if N6 is blank then M6 also to be blank.

#6 07-29-2005, 05:05 PM

That is a tremendously unhelpful reply.

If you want continued help, you would do well to explain *why* the
solution was incorrect.

In article <nowfal.1sy66s_1122667520.7205@excelforum-nospam.com>,
nowfal <nowfal.1sy66s_1122667520.7205@excelforum-nospam.com> wrote:

> That is not correct. thanks for quick response.

#7 07-29-2005, 05:05 PM

you want the word "TEL" in cell M6 if there is a 'telephone number ie.
555-790-3903' in cell N6?

#8 07-29-2005, 05:05 PM

nowfal wrote:
> Hi,
> very simple question if the cell N6 having telephone number then M6
> to show "TEL", and if N6 is blank then M6 also to be blank.
> regards
> selma d/o. nowfal
>
>
And what if N6 is not blank but does not have a telephone number?

Alan Beban

Welcome to the Excel Forum

Forum Statistics