multiple 'AND' inside IF

[Anonymous]

Hey! I am trying to create following formula. but it doesnt work. can anybody help please?

=If((1< Overdue Days AND Overdue Days <31 AND Current Status = ('01 OR '1') AND Balance > 0),'1-30 DAYS')

[vinieme12 · Accepted solution]

=If((1< Overdue Days AND Overdue Days <31 AND wildmatch(Current Status,'01','1') AND Balance > 0),'1-30 DAYS')

[jonathandienst]

Like this

=If((1 < Overdue Days And Overdue Days < 31 And Num(Current Status) = 1 And Balance > 0), '1-30 DAYS')

[Anonymous]

thank you. that's exactly what I'm looking for

[vinieme12]

Your Welcome

Use wildmatch for multiple values, but if you just want to match a single number stored as text you can also consider using NUM() as Jonathan has demonstrated.