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
Bookmarks