samiam41
asked on
Display DNP if value = 0, display Y if value is greater than 0
Hi Experts. Expanding on a formula provided to me by an expert on here, I'd like to display "DNP" if the value of a cell is 0 (zero) or Y if the value is greater than 0 (zero). Here is the formula provided to me.
=IF(G3>0,"Y","")
What would I use to for G3? Thanks for the help!
=IF(G3>0,"Y","")
What would I use to for G3? Thanks for the help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the quick response and formula! I appreciate it.
ASKER
=IF(G3>0,"Y","DNP")