Can this be modified to check for a text value instead of a numerical (n6=1)?
=IF(J3<1,0,IF(N6=1,G6,D6))

I'm getting the results I want, but I would prefer to use a letter instead
of a number.