AND

Returns a TRUE response if all values are true; returns a FALSE response if one or more values are false.

Use the && (AND) function as an alternative to the operator.

Use

AND(logical1,logical2,...) and replace logical1,logical2,... with the values that you want evaluated.

Formula Field Example
Formula Field Example

IF(AND(Price<1,Quantity<1),"Small", null)

This formula displays Small if the price and quantity are less than one. This field is blank if the asset has a price or quantity greater than one.