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


--
nowfal
------------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10003
View this thread: http://www.excelforum.com/showthread.php?threadid=391411

.

Relevant Pages

  • Re: Switch cells on input
    ... I was thinking about selecting a cell to enter values. ... Best regards ... agarwaldvk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11345 ...
    (microsoft.public.excel.programming)
  • Re: Convert font to lower case
    ... If suppose one particular cell always to be in upper case what to ... with regards ... nowfal's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10003 ...
    (microsoft.public.excel.misc)
  • Capital & Small Letters
    ... CAn any one give me code for identifing whether data in a cell is ... capital letter or small case? ... with regards ... ExcelPower's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30964 ...
    (microsoft.public.excel.programming)
  • Displaying Blank Cells
    ... This regards for more look than computation. ... function to have the FALSE text removed and have it just a blank cell. ... drvortex's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15896 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Is it possible?
    ... I'm missing something, but I don't see what it could be? ... Regards, ... >>> the status bar. ... >>> Click in a cell containing the formula. ...
    (microsoft.public.excel.worksheet.functions)