How to: free text cell, that can also assume a value depending on other cell?

Thank you so so much! It works perfectly!
Actually I meant C9, I just moved my old code out of the way since I figured it's probably useless xD But it was easy to change, I just exchanged (,2) to (,-2) in a few places

I thought I would be able to do several of these - I'm making a form that repeats itself 5 times down the sheet. The goal is to have C9 affected by E9, but also C40 by E40, C71 by E71, C102 by E102 and C133 by E133. I tried a bunch of things but I can't make it work. Any advice?

Also, thank you for the advice regarding using VBA and regarding IFS! I felt like I could keep organized easier with an IFS formula than with an IF, and didn't realize the disadvantages.