Announcements
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## multiple 'AND' inside IF

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')

1 Solution

Accepted Solutions
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
4 Replies
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Partner - Champion III

Like this

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

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

Champion III

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.

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Community Browser