I have a monthly spreadsheet that I am attempting to automate as much as possible. For example, if the value if cell G2 is less than 100, then cell H2 should have the following text "Activity normal", cell I2 should equal "N/A" and cell J2 should equal "Continue to monitor". If the value of cell G2 is 100 or greater, cells H2, I2, and J2 should be blank. The same pattern would be followed for each subsequent row. Any ideas on how this can be accomplished? Thanks in advance for your expertise!
Bookmarks