Thread: Using the IF fuction for multiple cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_7_] Roger Govier[_7_] is offline
external usenet poster
  
Posts: 1
Default Using the IF fuction for multiple cells

Hi Mike

=IF(COUNTIF(A2:D2)0,"Yes","No")

Strictly speaking the 0 isn't necessary, and it could be written as
=IF(COUNTIF(A2:D2),"Yes","No")

Make the final part "" if you want nothing to show in the cell instaed
of "no"


--
Roger Govier
------------------------------------------------------------------------
Roger Govier's Profile: http://www.thecodecage.com/forumz/member.php?userid=81
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=82572

Reply With QuoteReply With Quote