Thread: Referencing a range of columns and rows with the IF function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cliff
 
Posts: n/a
Default Referencing a range of columns and rows with the IF function
I am trying to use the following IF function to search a range of cells to
find the number 1 and then return either 1 or leave the cell blank. However,
it does not look at the range of cells.

A4=IF(A1:AS3=1),1,""

Any sugestions would help.
--
Cliff
Reply With QuoteReply With Quote