I cannot imagine in what sense your formula should result in a ratio that might easily be expressed as a percentage (in percentage format to say).
Are you sure, you didn't mean
- Code: Select all Expand viewCollapse view
=(high-low)/(result-low) *100
If so the factor 100 is the next point of criticism: It is superfluous then. Simply calculate
- Code: Select all Expand viewCollapse view
=(high-low)/(result-low)
and order Calc to display the calculated value in percentage format.
An important poit would be the arrangement of values: Values being
meaningful as a group should be placed in cells of
one row wherever feasible.
If you do so, it gets specifically simple to define your formula in a way that you can use it without any retyping in every row. The magic words are "named range" (which in fact is a named formula in this case) and "relative addressing".
Have a look into the attached example. It assumes my suspicion concerning your formula is correct. If not: Adapte the when defining the "named range" as needed - or come back for help.
The advice to group related data in one row should be good anyway.
Of course, you can then also enter and fill down the formula without using it to define a "named range".
On Windows 10: LibreOffice 7.0 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München