Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
=If((1< Overdue Days AND Overdue Days <31 AND wildmatch(Current Status,'01','1') AND Balance > 0),'1-30 DAYS')
=If((1< Overdue Days AND Overdue Days <31 AND wildmatch(Current Status,'01','1') AND Balance > 0),'1-30 DAYS')
Like this
=If((1 < Overdue Days And Overdue Days < 31 And Num(Current Status) = 1 And Balance > 0), '1-30 DAYS')
thank you. that's exactly what I'm looking for
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.