IF with multiple conditions

Thank you very much!
So first two conditions should be applied whole column and return only “SEND”. For some reason I have more results now, so I upload bigger file to help you understand the scope. But in a nutshell it should return SEND if:
1. As a rule if A:A is between 8-12 should return SEND without expectations.
Additionally:
2. IF A:A is between 12-30 and value in B:B is NOT “No info”, PLUS C:C value is less than 8 then it should return “SEND”
i. If value in B:B is “No info” PLUS A:A value is from 8-12 then it should return “SEND”. (This already work well) Thanks!

Formula

Formula:

Please Login or Register  to view this content.

You just need to restate your conditions, if previous conditions are met, you do not get to the later conditions
1. If B:B value is “No info” AND A:A value is from 8-12 then it should return “SEND”.
2. If B:B value is NOT “No info” AND C:C value is less than 8 then it should return “SEND”.
3. If value in A:A is 30 or higher than it should return: FUTURE
4. If value in A:A is 7 or lower than it should return: PAST

2. If B:B value is NOT “No info” AND C:C value is less than 8 and A:A >7, then it should return “SEND”.


=IF(AND(B2="No info",A2>=8,A2<=12),"Send",IF(AND(B2<>"No info",C2<=8,A2>7),"Send",IF(A2>=30,"Future",IF(A2<=7,"Past",""))))


is this what you mean?

Hey, thank you. It seems that it still returns SEND to A:A 30 or higher, unless the condition B:B "No info" is met. But if this condition is not met, then it shows that it should be sent, even if A:A is not between 8-12. And it still shows EMPTY when A:A is between 8-12

As I said restate your conditions in order if condition 1 is met you do not get to condition 2 etc

2. If B:B value is NOT “No info” AND C:C value is less than 8 then it should return “SEND”.
3. If value in A:A is 30 or higher than it should return: FUTURE

2 is fulfilled before 3 so if its is true it will

otherwise this will contunally be being tinkered with

someone will work out a formula

I think you are close, but have got a bit lost over brackets
write condition 1 as =IF(A801>=30,"Future",9999)
then write condition 2 as IF(A801<=8,"Past",9999)

now paste condition 2 into condition one replacing the 9999
IF(A801>=30,"Future",IF(A801<=8,"Past",9999))

now 3
IF(A801>=30,"Future",IF(A801<=8,"Past",IF(AND(A801>=8,A801<13),"Send",9999)))


and keep going for condition 3, 4, 5, etc, this is an easy way of keeping track of brackets in a long formula

tidying your formula
=IF(A801>=30,"Future",IF(A801<=8,"Past",IF(AND(A801>=8,A801<13),"Send",IF(AND(B801="No info",A801>=8,A801<13),"Send",IF(AND(B801<>"No info",C801<8,A801>7),"Send","")))))

For example, in cell A1, you have the number 2.28571428571428, as well as fractional numbers in all other cells, so I applied the TRUNC function to ensure that the set conditions are met without errors.
I corrected the error in the formula, but now in some cells the value FALSE appeared.
867711202