I want to create an excel document that substitutes multiple values. For example if in a cell I enter a 5. I want it to change it to a 100. If I enter a 4 I want it to change it to an 88. How do I create a formula that can substitute multiple values in one cell?
Thanks in advance. Let me know if I need to clarify anything.
Bookmarks