Forum Discussion
Excel ± percentages or figures
Dear Community, I am trying to produce an Excel formula, where the answer hinges on a ±percentage. An “IF” formula that returns 3 variables would be ideal, but Excel (it appears) only allows 2...
Hello Excel Community,
Thanks for the help I received,
I have finally worked out a solution to the problem I submitted earlier, and have added it in case anyone else might find it useful. Here's my Risk Reward formula:
=IF(P12>Ratio,"Reward",IF(OR(P12>0%,P12>(-Ratio)),"Mid Range",IF(P12<Ratio,"Risk")))
To explain: "P12" is just a reference cell. Use whatever cell you choose. "Ratio" is a Named Cell in which the Risk/Reward ratio is entered. This is changeable. The formula readjusts to whatever figure entered.
In the above, I have used a Risk/Reward ratio of 10%. If "P12" is above the 10% Risk/Reward ratio, it returns text "Reward". If below (-10%), "Risk", and if between, "Mid Range".
Use conditional formatting, if you wish, to further highlight the "Reward", "Risk" and "Mid Range" cell colours.
Any constructive comments appreciated. Philip. (Non Excel expert).
Thanks for the help I received,
I have finally worked out a solution to the problem I submitted earlier, and have added it in case anyone else might find it useful. Here's my Risk Reward formula:
=IF(P12>Ratio,"Reward",IF(OR(P12>0%,P12>(-Ratio)),"Mid Range",IF(P12<Ratio,"Risk")))
To explain: "P12" is just a reference cell. Use whatever cell you choose. "Ratio" is a Named Cell in which the Risk/Reward ratio is entered. This is changeable. The formula readjusts to whatever figure entered.
In the above, I have used a Risk/Reward ratio of 10%. If "P12" is above the 10% Risk/Reward ratio, it returns text "Reward". If below (-10%), "Risk", and if between, "Mid Range".
Use conditional formatting, if you wish, to further highlight the "Reward", "Risk" and "Mid Range" cell colours.
Any constructive comments appreciated. Philip. (Non Excel expert).