Thread: very simple logical

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

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

Sorry Bruce
My mistake, its working . thanks
regards

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.

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.

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

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