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:
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?