Thread: =IF cell needs to show blank if blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SteveG
 
Posts: n/a
Default =IF cell needs to show blank if blank

This should work.

=IF([cpleger.xls]Sheet1!N8=2,[cpleger.xls]Sheet1!I8,"")

This will return a blank if [cpleger.xls]Sheet1!N8 does not equal 2.


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=517023

Reply With QuoteReply With Quote