View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andim andim is offline
external usenet poster
 
Posts: 8
Default Referencing several cells with IF?

I just wanted to know if there is a way that I can check the content of
several cells with a function (possibly IF) to return a value in A1 if the
cells referenced all have a specific value.

To clarify I want A1 to return text "R" if B1, C1, D1 and E1 all have dates
in them.