I have this formula in N2
=IF(AND(A2="Y",H2>0),5,10)
I can't figure out how to get N2 to be blank if A2 is blank. This is for a golf league where if they play at least once within a month, they pay $5. If they haven't played within the month, they will pay $10 if they want to participate (A2). If they are not going to play at the end of the month, I would like N2 to be blank
Can someone help me with a 3rd criteria?
=IF(AND(A2="Y",H2>0),5,10)
I can't figure out how to get N2 to be blank if A2 is blank. This is for a golf league where if they play at least once within a month, they pay $5. If they haven't played within the month, they will pay $10 if they want to participate (A2). If they are not going to play at the end of the month, I would like N2 to be blank
Can someone help me with a 3rd criteria?