MrPJ_Harper
New Member
- Joined
- Mar 29, 2024
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
You
Hello all :
column t 29 calculates the Risk Reward Ratio "rrr" by getting values from =SUM(Q29)/-N29. I want u29 to calculate the rrr average. I do this by entering the following code =SUM(T29)/1. When I add new values in row 30 I want excel to automatically divide the value by 2 in u30, then again by 3 in u31. I have to manualy change dividing number by 1 then 2 then 3... how can I get excell to do this automatically?