Values based on different scenarios

[aueia]

I am trying to do something which I am not sure if it's possible doing without VBA - I am looking for a non-VBA solution.
The problem I am facing is in the context of a financial model, whose sample you can find here: financial model_example_v01.xlsx
I have a "Base case", an "Upside case", and a "Downside case". The way the model is built is the following:
• For the "Base case", my assumptions are COGS % Revenue, R&D % Revenue, and SG&A % Revenue. Based on these inputs, the EBIT margin is then an output when "Base case" is selected.
• For the "Upside case" and "Downside case", the only input is directly the EBIT margin (which in the "Base case" is an output); whilst the "Base case" inputs are now outputs based on the EBIT margin.
What I am specifically looking for is if there is any way of replacing the "15%" that is hardcoded in cells C5, C6, and C7 (which is the "Base case" EBIT margin) by a formula, without the need to create any helper cells, since the model I am actually working on has lots of rows, columns, and sheets where I am facing this issue.

 

[Muhammad_Usman]

what you want to replace instead of 15%

It is easily change with helper cell which you are not to be used

an other option is just find and replace

Select these 3 cell find in formula 15% replace with 10%,8% or which ever you want