Formula "either, or" With an overriding statement

Hello,

I'm having a bit of trouble with an excel spread sheet. I'm trying to write three conditions into a single cell. I need to have the cell auto population the three statements, "OPEN" "CLOSED" and "N/A"

The issue is I need a formula that pulls data from a cell (for example A1) that if =0, then it needs to say "N/A", or if > 0 it needs to say "OPEN" and an additional overriding statement from (for example A2) that if it is greater than >0, then the cell needs to say "CLOSED".

Is this possible?

HOLY $#&*! That did it! I'm currently in a work event, and was trying to figure this out. I am truly in your debt!

i hate to ask... but I have a similar issue on the same spread sheet where I need 3 statements. I tried to figure it out from the formula you gave me but as I've been working for the past 9 hours straight. My brain just isn't up to snuff lol.

Currently I have the below formula, but I need to add a "N/A" if there is a "0" in "G125" I can't remember if this is an "IFS" formula or if need to place an "OR" in the formula, or maybe I'm wrong all together. lol

=IF(TODAY()<=G125,"YES", "NO")

try

=IF(G125=0,"N/A",IF(TODAY()<=G125,"YES", "NO"))