IF AND Nested Functions - Formula Not Working

P

Pickles

Joined
Feb 22, 2016
Messages
1
Reaction score
0
Hi

I've trying to get several functions in one formula to work. I can get it working with just one.

=IF(AND(G61="1",SUM(M40:M52)+M61<360),"Check","")​

G61 is a drop down box and have options ranging up to 10+. So for the second option, if it was a lone formula, it would read:

=IF(AND(G61="2",SUM(M40:M52)+M61<720),"Check","")
​
Each number (1, 2, 3, 4, etc) have a different minimum value that needs to shout CHECK if it's below that figure. How do I go about making this into one long, continuous formula without Excel shouting at me?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIFS BETWEEN WORKSHEETS HELP 1
Long "IF" formula 5
Arrayformulas with either/or nested to sumproduct if eitherconditions are true 13
How do I use 'between' 95% and 100% for a nested IF function? 4
Nested IF Functions with OFFSET 3
IF function says too many nested 1
Nested IF & MAX Function 4
nested IF without repeating the condition? 1

Top