Sorry if I'm not posting this in the right forum section, the titles of the sections are confusing to what my problem is about. I'm trying to work out the operations in a formula that takes in 3 custom input values, and results in a specific value. I can't seem to figure out the operations, the method the formula uses to turn the input values into the output. The formula follows a specific context but I'll explain a scenario that describes the same problem.
In this scenario lets say there are three different variables that a specific formula turns into values I know:
Regards
Aqualight
In this scenario lets say there are three different variables that a specific formula turns into values I know:
| Variable A | Variable B | Variable C | Output |
| 100 | 125 | 0 | 0 |
| 100 | 125 | 25 | +06.25 |
| 100 | 125 | 50 | +12.50 |
| 100 | 125 | 75 | +18.75 |
| 100 | 125 | 100 | +25.00 |
| 100 | 100 | 0 | 0 |
| 100 | 100 | 25 | 0 |
| 100 | 100 | 50 | 0 |
| 100 | 100 | 75 | 0 |
| 100 | 100 | 100 | 0 |
| 100 | 75 | 0 | 0 |
| 100 | 75 | 25 | -06.25 |
| 100 | 75 | 50 | -12.50 |
| 100 | 75 | 75 | -18.75 |
| 100 | 75 | 100 | -25.00 |
| 100 | 50 | 0 | 0 |
| 100 | 50 | 25 | -12.50 |
| 100 | 50 | 50 | -25.00 |
| 100 | 50 | 75 | -37.50 |
| 100 | 50 | 100 | -50.00 |
| 100 | 25 | 0 | 0 |
| 100 | 25 | 25 | -18.75 |
| 100 | 25 | 50 | -37.50 |
| 100 | 25 | 75 | -56.25 |
| 100 | 25 | 100 | -75.00 |
| 100 | 0 | 0 | 0 |
| 100 | 0 | 25 | -25.00 |
| 100 | 0 | 50 | -50.00 |
| 100 | 0 | 75 | -75.00 |
| 100 | 0 | 100 | -100.00 |
Regards
Aqualight