very simple logical

  • Thread starter Thread starter nowfal
  • Start date Start date
N

nowfal

Hi,
very simple question if the cell N6 having telephone number then M
to show "TEL", and if N6 is blank then M6 also to be blank.
regards
selma d/o. nowfa
 
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
 
That is a tremendously unhelpful reply.

If you want continued help, you would do well to explain *why* the
solution was incorrect.
 
you want the word "TEL" in cell M6 if there is a 'telephone number ie.
555-790-3903' in cell N6?
 
nowfal said:
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
Click to expand...
And what if N6 is not blank but does not have a telephone number?

Alan Beban
 
Back
Top