if formula for more than 7 lookups?

[grounded]

Hi All ~

My question is: I have several cells [M5, M9, M13, M17, M21, M25, & M29] that subtract from various areas within my spreadsheet. When one of these cells reaches zero - all is good but when any of the cells go below zero I need to put a #1 in cell Q3. I tried the if formula but could only get it to work M5, 9, 13, & 17 and I also tried if(m5,-1,if(m9 ..... ect) by than I got -1 in Q3. I'm new to excel [tho I think this spreadsheet is trying to make me an expert!] so any help would be great - thanks again!

[rylo]

Hi

Try putting this in Q3
=IF(MIN(M5,M9,M13,M17,M21,M25,M29)<0,1,"")

rylo

[Portuga]

See if this helps:

In Q3:

Please Login or Register  to view this content.

[Trebor76]

Hi there,

Using a combination of the IF and OR functions, the following will put a 1 in Q3 if any of the mentioned cells in column M are less than zero, or else it will return a zero.

HTH

Robert

=IF(OR(M5<0,M9<0,M13<0,M17<0,M21<0,M25<0,M29<0),1,0)