I am having trouble getting an IF)AND statement to work
=IF(AND(J12=5,K12="Y"),"5Y",J12)
In cell J12, value can be 1 to 5 in cell K12 I have a match formula referencing another cell so either Y or #N/A is returned.
so I was hopng that if J12 =5 and K12 = Y then 5Y is displayed, otherwise just...