Moderated Libre Calc and Equating Two Cells
|
K0LNY
Hi,
I am trying to figure out how to do some calculations of two cells with countif formulas in them, in another cell. So I have a row of working results in cells with countif, they count things in upper cells. So, in a cell, let's say B2107, I want it to show the results from multiplying B2105 times 100, and then divide that by what is in B2106. So in cell B2107, I put: =(b2105*100/B2106) I tried it without the parenthesis too. The cell only reads "formula" when I move over it. The two other cells work fine, displaying the results of their formulas. Can I do formulas that include other formulas? Thanks. Glenn |
|
|
|
I haven't used Libre Calc in ages, but this sounds like it could be its equivalent of the string of pound signs in Excel when the column is not wide enough to display the result of the calculation.
It can't hurt to widen that column just to see if it gets rid of that issue. If it doesn't, you can shrink it back. -- Brian - Virginia, USA - Windows 11 Pro, 64-Bit, Version 22H2, Build 22621; Office 2016, Version 16.0.15726.20188, 32-bit; Android 12 (MIUI 13) It’s not lack of contact with the world off campus that leads to the liberal views common in academia — it’s being trained to think critically and practicing this craft daily as we look at the world around us that makes us the libs conservatives so dislike. ~ Eliot A. Brenowitz, Seattle; New York Times, Letters, Tales of Town and Gown: Is the Campus Isolated?, August 20, 2022 |
|
|
|
K0LNY
toggle quoted message
Show quoted text
I wondered about that, but it should only be a two
or three digit number in the field, and I didn't hear the ## that usually shows
up when this is the case, but I will give that a try just to be
sure.
Glenn ----- Original Message -----
From: Brian Vogel
Sent: Saturday, January 14, 2023 10:03 PM
Subject: Re: Libre Calc and Equating Two Cells It can't hurt to widen that column just to see if it gets rid of that issue. If it doesn't, you can shrink it back. -- Brian - Virginia, USA - Windows 11 Pro, 64-Bit, Version 22H2, Build 22621; Office 2016, Version 16.0.15726.20188, 32-bit; Android 12 (MIUI 13) It’s not lack of contact with the world off campus that leads to the liberal views common in academia — it’s being trained to think critically and practicing this craft daily as we look at the world around us that makes us the libs conservatives so dislike. ~ Eliot A. Brenowitz, Seattle; New York Times, Letters, Tales of Town and Gown: Is the Campus Isolated?, August 20, 2022 |
|
|
|
On Sat, Jan 14, 2023 at 08:14 PM, K0LNY wrote:
=(b2105*100/B2106)- Even though it absolutely should NOT make any difference, try putting this in as the formula instead: =(B2105*100)/B2106 -- Brian - Virginia, USA - Windows 11 Pro, 64-Bit, Version 22H2, Build 22621; Office 2016, Version 16.0.15726.20188, 32-bit; Android 12 (MIUI 13) It’s not lack of contact with the world off campus that leads to the liberal views common in academia — it’s being trained to think critically and practicing this craft daily as we look at the world around us that makes us the libs conservatives so dislike. ~ Eliot A. Brenowitz, Seattle; New York Times, Letters, Tales of Town and Gown: Is the Campus Isolated?, August 20, 2022 |
|
|
|
K0LNY
toggle quoted message
Show quoted text
That does make mathematical sense, I'll try that
out tomorrow.
----- Original Message -----
From: Brian Vogel
Sent: Saturday, January 14, 2023 10:16 PM
Subject: Re: Libre Calc and Equating Two Cells =(b2105*100/B2106)- Even though it absolutely should NOT make any difference, try putting this in as the formula instead: =(B2105*100)/B2106 -- Brian - Virginia, USA - Windows 11 Pro, 64-Bit, Version 22H2, Build 22621; Office 2016, Version 16.0.15726.20188, 32-bit; Android 12 (MIUI 13) It’s not lack of contact with the world off campus that leads to the liberal views common in academia — it’s being trained to think critically and practicing this craft daily as we look at the world around us that makes us the libs conservatives so dislike. ~ Eliot A. Brenowitz, Seattle; New York Times, Letters, Tales of Town and Gown: Is the Campus Isolated?, August 20, 2022 |
|
|
|
Bump to ask if a solution has yet been found?
-- Brian - Virginia, USA - Windows 11 Pro, 64-Bit, Version 22H2, Build 22621; Office 2016, Version 16.0.15726.20188, 32-bit; Android 12 (MIUI 13) It’s not lack of contact with the world off campus that leads to the liberal views common in academia — it’s being trained to think critically and practicing this craft daily as we look at the world around us that makes us the libs conservatives so dislike. ~ Eliot A. Brenowitz, Seattle; New York Times, Letters, Tales of Town and Gown: Is the Campus Isolated?, August 20, 2022 |
|
|
|
K0LNY
toggle quoted message
Show quoted text
Hi Brian,
I had family stuff yesterday and didn't get to try
your equation, but I just now did and yours worked.
I also tried it without any parenthesis, and that
worked too.
=b2105*100/b2106
Thanks.
----- Original Message -----
From: Brian Vogel
Sent: Monday, January 16, 2023 10:00 AM
Subject: Re: Libre Calc and Equating Two Cells -- Brian - Virginia, USA - Windows 11 Pro, 64-Bit, Version 22H2, Build 22621; Office 2016, Version 16.0.15726.20188, 32-bit; Android 12 (MIUI 13) It’s not lack of contact with the world off campus that leads to the liberal views common in academia — it’s being trained to think critically and practicing this craft daily as we look at the world around us that makes us the libs conservatives so dislike. ~ Eliot A. Brenowitz, Seattle; New York Times, Letters, Tales of Town and Gown: Is the Campus Isolated?, August 20, 2022 |
|
|