= formula 1 AND formula 2 (didn't work) ;
= formula1,formula2(didn't work)

=AND([Column1]>[Column2], [Column1]<[Column3]) - Is 15 greater than 9 and less than 8?
Value -(No)

    =IF(AND([Column1]>[Column2], [Column1]<[Column3]), "OK", "Not OK") - If 15 is greater than 9 and less than 8, return "OK".
    Value - (Not OK)