=IF(COUNTIF(A1:AS3,1)0,1,"")

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Cliff" wrote in message
...
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