At 15:01 13/06/2021 +0200, Hylton Conacher wrote:
A simple sum will do it i.e.: In cell Y4 insert [...]
=SUM(M18-$W$4)
I'm often puzzled by suggestions such as this. In what way do you
think that =SUM(Xm-Yn) differs from =Xm-Yn? The minus sign effects
the subtraction between two values,
At 11:20 12/06/2021 -0400, Vince Bonly wrote:
I would greatly receiving an explanation of a formula or function in
Calc that updates the data within cell $Y$4 each time the data in
column [M] changes. The formula in $Y$4 =$M18-$W$4.
Generally speaking, this process is automatic in
Hi Hylton:
Thank you, OM, for giving this problem some thought; I do appreciate
your suggestion/comments.
I understand your approach in your suggested solution; however, it does
not satisfy my requirements. The numerical data that is entered, or
calculated in this situation, within the rows
Hi Vince,
On 2021/06/12 17:20, Vince@Verizon wrote:
Hello:
Using LO vers 7.1.3.2 (x64) on desktop Windows 10 Home (64-bit).
I would greatly receiving an explanation of a formula or function in
Calc that updates the data within cell $Y$4 each time the data in column
[M] changes. The formula
Den lör 12 juni 2021 kl 21:51 skrev John Kaufmann :
> On 2021-06-12 13:59, Johnny Rosenberg wrote:
> > Den lör 12 juni 2021 kl 01:05 skrev Dutton:
> >
> >> In cell A1 there's the number 1230
> >> In cell A2 I want the number to appear as 12:30 (a time figure)
> >
> > If you only mean ”appear”,
Ahh. Now I understand. I can see how that might be useful.
Sorry, but I don't know a way to do that right now.
Seems like that might be a relatively easy thing to do,
but I don't know how.
Mike
On 6/9/21 8:24 PM, Alan B wrote:
Not at all what I'm trying to do. Distinct values have their