Hi,
Was wonting a formula to solve problem, please refer to image attached thanks.
Corca.
Let’s assume that the sample data in the picture you provide is in the cells A1:F4.
Aside: it would have been better to provide a sample spreadsheet, so helpers aren’t required to type out data to be able to test a solution. For this reason I’ll just give some steps you might take. Please refer to attached image.
1 Like
Spreadsheet attached.
I would like if it’s possible for the formula to be one.
example.ods (19.9 KB)
I know the individual steps in the formula but having troube to put it all in one formula.
thanks,
Corca
The formula could be e.g.
=LET(min_value;MIN(F6:F9);min_adjusted;IF(min_value=0;1;min_value*2);VLOOKUP(min_value;F6:G9;2;0)*min_adjusted)
But why would you want it that way? Spreadsheets are not limited in the number of cells. Having calculations split into columns helps finding errors. What is the reason to make formulas that are harder to manage?
Possibly the same reason that the Obfuscated Perl Contest was created. Possible outcome;
When I wrote this formula, only God and I knew what it did. Now only God knows.
1 Like
By the way: your sample has this:
| Exmple it minimum value found is 3 | |
|---|---|
| 1 | 3 |
| 2 | N/A |
| 3 | 6 |
| 4 | Answer 88 x 3 = 264 |
But it’s wrong: on step 4, it multiplies by minimum, not by adjusted minimum. Errors are possible, both in expectation, or in formula, or in software. Which, again, shows why splitting calculations into small steps is helpful.
1 Like