Comment removed
AnZarVid 2 months ago
In cell C13 I want it to reflect "OPEN" of "CLOSED" statement.
So if cell R13 >0 then cell C13 = "OPEN".
I have in cell C13 =if(R13="","","OPEN")
How can I get cell C13 to reflect when cell S13 >0.
How can you get it to change from "OPEN" to "CLOSED" using cell R13 for the "OPEN" and cell S13 for the "CLOSED"?
I have tried a VBA and do not want to use a VBA if I can help it.
2009jaxs 1 year ago
Comment removed
AnZarVid 2 months ago
In cell C13 I want it to reflect "OPEN" of "CLOSED" statement.
So if cell R13 >0 then cell C13 = "OPEN".
I have in cell C13 =if(R13="","","OPEN")
How can I get cell C13 to reflect when cell S13 >0.
How can you get it to change from "OPEN" to "CLOSED" using cell R13 for the "OPEN" and cell S13 for the "CLOSED"?
I have tried a VBA and do not want to use a VBA if I can help it.
2009jaxs 1 year ago