IF statement for a range

[rhudgins]

Starting in O138 I would like a statement that says IF there is a value in the range R111:AQ111 then return it to O138 and if not then return -5% to O138. I would liketo be able to drag this formula down to O148.

[Paul]

Hi Rhudgins, try:

=IF(COUNT(R111:AQ111)>0,LOOKUP(9.999E+307,R111:AQ111),-0.05)

Format the cell as Percent.