Added: 3 years ago
From: excelteacher
Views: 20,432
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (2)

Sign In or Sign Up now to post a comment!
  • Comment removed

  • 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.

Loading...
Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more