Multiple If arguments

[rustynailed]

Hi there
I'm attempt to create an argument based on 2 criteria
I have these 2 argument working. what I want to do is combine them together so they are one single argument. Can anyone assist?

=IF(AND(L2 <>"monthly", S2 <2), "Completion Letter", "Insufficient Letter")

=IF(AND(L2 <>"fortnightly", S2 <4), "Completion Letter", "Insufficient Letter")

 

[bolo]

Hi there
I'm attempt to create an argument based on 2 criteria
I have these 2 argument working. what I want to do is combine them together so they are one single argument. Can anyone assist?

=IF(AND(L2 <>"monthly", S2 <2), "Completion Letter", "Insufficient Letter")

=IF(AND(L2 <>"fortnightly", S2 <4), "Completion Letter", "Insufficient Letter")

Try This

=IF(OR(AND(L2 <>"monthly", S2 <2),AND(L2 <>"fortnightly", S2 <4)), "Completion Letter", "Insufficient Letter")

Regards

Bolo

 

[T. Valko]

Hi there
I'm attempt to create an argument based on 2 criteria
I have these 2 argument working. what I want to do is combine them together so they are one single argument. Can anyone assist?

=IF(AND(L2 <>"monthly", S2 <2), "Completion Letter", "Insufficient Letter")

=IF(AND(L2 <>"fortnightly", S2 <4), "Completion Letter", "Insufficient Letter")

Maybe this...

=IF(OR(AND(L2<>"monthly",S2<2),AND(L2<>"fortnightly",S2<4)),"Completion Letter","Insufficient Letter")

 

[rustynailed]

Thanks that worked great. However I would like to move one step further
based on this, I want to modify it.

IF A:Bs is =>3 "Default letter" or the rest of the argument stands

=IF(OR(AND(L2 ="monthly", S2 <=2),AND(L2 ="fortnightly", S2 <=4)), "Completion Letter", "Insufficient Letter")

 

[T. Valko]

Thanks that worked great. However I would like to move one step further
based on this, I want to modify it.

IF A:Bs is =>3 "Default letter" or the rest of the argument stands

=IF(OR(AND(L2 ="monthly", S2 <=2),AND(L2 ="fortnightly", S2 <=4)), "Completion Letter", "Insufficient Letter")

Not sure what this means:

IF A:Bs

 

[rustynailed]

Sorry my bad,

IF AB2 is =>3 "Default letter" or the rest of the argument stands

=IF(OR(AND(L2 ="monthly", S2 <=2),AND(L2 ="fortnightly", S2 <=4)), "Completion Letter", "Insufficient Letter")

 

[T. Valko]

Sorry my bad,

IF AB2 is =>3 "Default letter" or the rest of the argument stands

=IF(OR(AND(L2 ="monthly", S2 <=2),AND(L2 ="fortnightly", S2 <=4)), "Completion Letter", "Insufficient Letter")

Try this...

=IF(AB2>=3,"Default letter",IF(OR(AND(L2="monthly",S2<=2),AND(L2 ="fortnightly",S2<=4)),"Completion Letter","Insufficient Letter"))