=IF((AND([Status]="New",[Age]>2,1)
AND says not enough criteria.
First part (w/0 AND) works fine on it's own and will return "1" if the field is "New".
But using AND or joining with "," keeps giving me error if I want to also evaluate if the Age column >2.
What is the correct syntax to return the value 1 if both Status is "New" and Age is >2 but leave blank otherwise?
Any help appreciated dax alternative is fine too.
=IF([Status]="New",1,IF([Age]>2,1))
This gives everything as 1.
AND says not enough criteria.
First part (w/0 AND) works fine on it's own and will return "1" if the field is "New".
But using AND or joining with "," keeps giving me error if I want to also evaluate if the Age column >2.
What is the correct syntax to return the value 1 if both Status is "New" and Age is >2 but leave blank otherwise?
Any help appreciated dax alternative is fine too.
=IF([Status]="New",1,IF([Age]>2,1))
This gives everything as 1.
Last edited:
