If-Then Statements & a Range of Values I have a table where each column represen

Question

If-Then Statements & a Range of Values

I have a table where each column represents a month, and then for each month a value is entered, for example:

I would like to write a function that basically says that if each and every value entered per month is less than zero, it does one calculation, else it does another calculation. My mind is thinking:

=if(A2:L2<0, "do calc 1", "do calc 2")

But that is not valid syntax... the "A2:L2<0" part... what I'm looking for is that if A2<0 and B2<0 andC2<0 and D2<0 and E2<0, etc., you get the picture.

I'm sure this is not hard to do and I bet when I hear the replies I'll think, "DOH!" nevertheless I guess I'm having a brain fart today!

Anyone able to point me in the right direction??

Thanks!!!

A B C D E ... L 1 January February March April May ... December 2 (3,610) (10,000) (10,000) (10,000) (10,000) ... (10,000)

Explanation / Answer

Hi..

Try,

=IF(AND(A2:L2<0), "do calc 1", "do calc 2")

This is a Array formula so you have to enter it by pressing Ctrl+Shift+Enter simultaneously. If entered correctly then it will show curly brackets before and after the formula...

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---