Getting the percentage results from a blood test.

Discuss the spreadsheet application

Getting the percentage results from a blood test.

Postby RichardPrincipal » Thu Jul 16, 2020 8:55 pm

deleted posting the old formula did work, but now the new one does not work
Last edited by RichardPrincipal on Thu Jul 16, 2020 10:42 pm, edited 1 time in total.
Openoffice 4.1.7, Windows 10
Posts: 13
Joined: Sun May 24, 2020 10:02 pm

Re: Getting the percentage results from a blood test.

Postby Lupp » Thu Jul 16, 2020 10:11 pm

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
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".
(19.1 KiB) Downloaded 33 times
On Windows 10: LibreOffice 7.0 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
Lupp from München
User avatar
Posts: 2999
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Return to Calc

Who is online

Users browsing this forum: mike.stirton and 9 guests