Help with If/AND/OR

[Effendi]

Hello,

I am new to using formulas and struggling to get this right.

I've attached a file to illustrate the True condition I'm trying to achieve with my IF statement.

I'm ok using IF statements alone, however, I've a feeling this requires a combination.

Hope I was clear in my explanation and workbook example.

Thanks.
Effendi


Condition for True

C2=Unapproved and D2=100
OR
C2=Unapproved and B2<Today
OR
C2=Approved and D2<100

 

[eibi]

Will this work?

=IF(OR(AND($C2="Unapproved",$D2=100),AND($C2="Unapproved",$B2=TODAY()),AND($C2="Approved",$D2<100)),TRUE,FALSE)

See attached for reference.

If you just want TRUE/FALSE as your outputs, you actually don't need the IF at all...this will return the same results:

=OR(AND($C7="Unapproved",$D7=100),AND($C7="Unapproved",$B7=TODAY()),AND($C7="Approved",$D7<100))

 

[BelindaJoy]

Eibi, Those are clean solutions I can follow but I'm confused about your reasoning in one place: both your solutions use the condition "$B2=Today()" when Effendi referred to "B2<Today" being the condition required with "unapproved" for a true result. Was there a reason for the change or was that just something overlooked/a typo?

 

[Effendi]

Many thanks Eibi! It works, just changed the date operator to < and all conditions are met.

Thank you so much!

Best.

Effendi

 

[John Jairo V]

Hi!

A bit short:
=OR(AND(C2="Unapproved",OR(D2=100,B2<TODAY())),AND(C2="Approved",D2<100))
Blessings!

 

[Effendi]

Thank you John! This community rocks!