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.
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.
Hi Rhudgins, try:
=IF(COUNT(R111:AQ111)>0,LOOKUP(9.999E+307,R111:AQ111),-0.05)
Format the cell as Percent.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks