1. Jfw | Main
  2. Topics

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

Brian Vogel
 

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
 


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 -----
Sent: Saturday, January 14, 2023 10:03 PM
Subject: Re: Libre Calc and Equating Two Cells

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

Brian Vogel
 

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
 


That does make mathematical sense, I'll try that out tomorrow.
 

----- Original Message -----
Sent: Saturday, January 14, 2023 10:16 PM
Subject: Re: Libre Calc and Equating Two Cells

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

Brian Vogel
 

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
 


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 -----
Sent: Monday, January 16, 2023 10:00 AM
Subject: Re: Libre Calc and Equating Two Cells

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

1 - 7 of 7