Thread: Can a value from a different cell be the false answer in =If quest
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peter1999
 
Posts: n/a
Default Can a value from a different cell be the false answer in =If quest

=IF(ISBLANK(E6),"Not Given",E6)

If you have another column where a phone number might be you could
write:

=IF(ISBLANK(E6),IF(ISBLANK(F6),"Not Given",F6),E6)

Where F6 represents the cell where you might or might not have a phone
number.

Peter


--
Peter1999
------------------------------------------------------------------------
Peter1999's Profile: http://www.excelforum.com/member.php...o&userid=33997
View this thread: http://www.excelforum.com/showthread...hreadid=549045

Reply With QuoteReply With Quote