Steve Greaves wrote:
Hi, team.
When building a formula in Excel, the tool tip does not go *BOLD,* as
you type, unlike Microsoft's Excel.
May I suggest that this could be developed in a newer version?
Examples below:
Microsoft's has the BOLD type to help...
Developers don&#x
Hi, team.
When building a formula in Excel, the tool tip does not go BOLD, as you type,
unlike Microsoft's Excel.
May I suggest that this could be developed in a newer version?
Examples below:
Microsoft's has the BOLD type to help...
'oh! I MISSED that staff meeting! Yup, it's there but I never noticed that
part!
>> Mathematically I could / should have written it as...
>>
>> If K102 < 14 then L102 = "Yes", else L102 = "No"
>I'll continue to assume Calc until proven
on a different computer ( a more often used iMac)
Version: 3.1.1 (Build: 9420)
The formula I should have used works logically elsewhere outside OO, but not in
the OO document.
When asking originally, I errored using the above as a two part formula... that
actually contained a problem in the fi
ersion: OpenOffice 4.1.8 AOO418m3 (Build:9803)
...and on a different computer ( a more often used iMac)
Version: 3.1.1 (Build: 9420)
The formula I should have used works logically elsewhere outside OO, but not in
the OO document.
When asking originally, I errored using the above as a two part f
las to get needed
> values.
>
> I'd like to configure a "Yes / No' location (set of adjacent cells)
> to identify if a value is greater than / less than a boundary.
> If > 14 then report "No".
> If < or = 10 then report "Yes".
>
> My only i
I do apologise it must have been sql washer I used it, Howartb if that's your
attitude it's the last time I will try to help
On Fri, 3 Nov 2023, at 14:36, Brian Barker wrote:
> On 2023-11-02 22:06, Robin Lord wrote:
>>The IIF function will do what you want easily
>
> On Thu, 2 Nov 2023, at 21:55,
On 2023-11-02 22:06, Robin Lord wrote:
The IIF function will do what you want easily
On Thu, 2 Nov 2023, at 21:55, David Robley wrote:
Unfortunately IIF isn't implemented in AOO Calc.
At 14:12 03/11/2023 +, Robin Lord wrote:
I think it is I have used it in the past, of is aoo different
t;>> I'd like to configure a "Yes / No' location (set of adjacent cells) to
>>>> identify if a value is greater than / less than a boundary.
>>>> If > 14 then report "No".
>>>> If < or = 10 then report "Yes".
>>
p of basic formulas to get needed
values.
I'd like to configure a "Yes / No' location (set of adjacent cells) to identify
if a value is greater than / less than a boundary.
If > 14 then report "No".
If < or = 10 then report "Yes".
My only issue is not knowi
I'd like to configure a "Yes / No' location (set of adjacent cells) to
>> identify if a value is greater than / less than a boundary.
>> If > 14 then report "No".
>> If < or = 10 then report "Yes".
>>
>> My only issue is no
> 14 then report "No".
If < or = 10 then report "Yes".
My only issue is not knowing how to construct the formula correctly.
Any help appreciated.
Thanks
Don
Using a couple different versions of OO on 3 different older Macs.
--
or = 10 then report "Yes".
My only issue is not knowing how to construct the formula correctly.
Any help appreciated.
Thanks
Don
Using a couple different versions of OO on 3 different older Macs.
-
To unsubscribe, e
On 2023/05/02 16:22:10 Czesław Wolański wrote:
> It follows that the function
> RECEIVED(settlementdate; maturitydate; purchasevalue; discountrate; basis)
> should return the same value as the formula
> = purchasevalue * ( 1 - discountrate *
> YEARFRAC(settlementdate;maturitydate
Hi,
On 2023/05/02 15:59:01 Vijay Vardhan wrote:
> Correct formula is as follows:
> RECEIVED = PurchaseValue*(1/( 1 -
> (DiscountRate*days_difference/days_in_year))).
You're right. For a zero coupon bond [1]:
received = purchasevalue + received * discountrate * ( days_to_maturity /
This is not my formula. It's your formula on the webpage of function
RECEIVED and is incorrect formula.
Correct formula is as follows:
RECEIVED = PurchaseValue*(1/( 1 -
(DiscountRate*days_difference/days_in_year))).
On Tue, May 2, 2023, 1:07 AM Andrew Pitonyak wrote:
>
> I thin
I think that your formula is missing the "discount" or percentage. I have seen
the formula published on the Microsoft help pages and it too does not show any
derivation.
On Monday, May 01, 2023 12:24 EDT, Vijay Vardhan wrote:
The formula of function RECEIVED for calculating rece
The formula of function RECEIVED for calculating received value on maturity
is incorrect on the webpage of function RECEIVED.
RECEIVED = purchasevalue / ( 1 - days_difference/days_in_year). This is an
incorrect formula. There is no formula on the webpage of 'Derivation Of
Financial For
nk if what you have are actually text
values. If you incorporate a text value into a numerical formula in
this way, the text value is automatically converted on the fly to its
numerical value. So - perhaps surprisingly - the same formula will
work for text values.
Incidentally, it may be helpfu
I’m not a power user, I’m a ‘work-around’ person, and I've done something
roughly similar to this before. Here are my work-arounds for this situation:
Calculation work-arounds.ods
Description: application/vnd.oasis.opendocument.spreadsheet
PCS
> On 9 Apr 2022, at 2:31 pm, rcrmon...@wi.rr.co
The right way to do it is convert HH:MM to seconds. Then calculate
your billing rate PER SECOND (amount / 60), and multiply it with the
first value.
At least that' s how I'd do it.
Hope this helps...
FC
On 09/04/2022, rcrmon...@wi.rr.com wrote:
> My pay is basically done by the minute. When I r
My pay is basically done by the minute. When I record the hours I
worked, it is expressed 11:55 or 11 hours, 55 minutes. When I record my
hours in OpenOfficecalc, I currently convert the minutes into fractions
of an hour--ie 55 minutes=.916--which I'm not sure is accurate. Is
there a way to
Greetings,
I am using AOO 4.1.6 under Slackware Linux 14.2.
In Writer, I am trying to create a blank data entry form or template
with a table to be filled out later, so all of the to-be-entered values
in the table's cells are zero or null. In a few cells I want to create a
formula th
A simple =D1*E1 placed in F1 should do what you want - assuming that D
and E contain numbers, not text. You can check the type of content in
cells using View | Value Highlighting or the keyboard shortcut Ctrl+F8.
The formula can then be copied or dragged down as needed.
Text cells are
been battling to use a simple formula in a spreadsheet to cause each cell
'Fx' to equal the contents of cell 'Ex' of the same row multiplied by the
contents of cell 'Dx'. I have done this in MS Office v2 to v6 and 97, Star
Office on both OS/2 & various Linux vers
Replacing an Number Field with text as in your formula will have impact
on calculations like COUNT() or AVERAGE()
Also your formula doesn't take into account negative numbers
Suppressing the display of zeros in your Options works on your Display,
but it will not suppress your it when
you
lue in cells yet to be populated and to do so
I use the =IF(Target Cell>0;Actual Formula;"") setup.
This works well for me upon the Target Cell being the result or a
manual entry.
However, this doesn't work when the Target Cell contains a formula. (
I appreciate that the formu
suite - Thanks.
I love to hide the "0" value in cells yet to be populated and to do so
I use the =IF(Target Cell>0;Actual Formula;"") setup.
This works well for me upon the Target Cell being the result or a
manual entry.
However, this doesn't work when the Target C
Great suite - Thanks.
I love to hide the "0" value in cells yet to be populated and to do so I
use the =IF(Target Cell>0;Actual Formula;"") setup.
This works well for me upon the Target Cell being the result or a manual
entry.
However, this doesn't work whe
Got it!
Thank's a lot Brian; I was thinking and searching for a more complex
solution.
--
Michel Donais
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.
At 19:21 01/07/2018 -0400, Michel Donais wrote:
I have a huge spreadsheet and have to change a value in all
formulas. formula are like this: each columns are this style 'a'
identify a column '2-4-5-6' etc are the lines
Er, that's how spreadsheets are!
=sum(a3*e3)+(b
I have a huge spreadsheet and have to change a value in all formulas
formula are like this:
each columns are this style 'a' identify a column '2-4-5-6' etc are
the lines
=sum(a3*e3)+(b4*e4)+(a5*e5)+(a6*e6)+(a7*e7)+. and so on
untill (zza256)
I have to c
On 3/15/2018 11:21 AM, WA.TWORSX via AOL wrote:
Martin:
Thank you for your reply/comments. I understand and do appreciate
your frustration; especially since there are many absolute ($A$1))
references are, and must be, used.
I am aware that there are possibilities that two, or more, bowler
Martin:
Thank you for your reply/comments. I understand and do appreciate your
frustration; especially since there are many absolute ($A$1)) references
are, and must be, used.
I am aware that there are possibilities that two, or more, bowlers may
have the same numerical game score. I am a
, found in cell F75),
and each score that follows in cells F76:F109, with the name of the bowler,
that made the corresponding game score, (in this instance, Bob M., found in
cell F57). I want to display the appropriate resulting bowler names within
cells H75:H109.
Is there an AOO-Calc f
, with the name of the bowler,
>> that made the corresponding game score, (in this instance, Bob M., found in
>> cell F57). I want to display the appropriate resulting bowler names within
>> cells H75:H109.
>>
>> Is there an AOO-Calc formula/multiple fu
gt; To: users@openoffice.apache.org
> Cc: mar...@groenescheij.com
> Subject: Re: Need Formula to use with Results of LARGE( ) Function's Result-
> Lookup?
>
> This is the fourth version of your problem.
> Keep trying, if you don't succeed by version 21 I will have a look in
WHY DOESN'T 'BLOCKING SENDER' WORK WITH YOU ON MY JUNK
MAIL??
-Original Message-
From: Martin Groenescheij
Sent: Thursday, March 15, 2018 8:18 AM
To: users@openoffice.apache.org
Cc: mar...@groenescheij.com
Subject: Re: Need Formula to use
me of
the bowler, that made the corresponding game score, (in this instance,
Bob M., found in cell F57). I want to display the appropriate
resulting bowler names within cells H75:H109.
Is there an AOO-Calc formula/multiple functions that can be used to
solve the task at hand? I have look
.
Is there an AOO-Calc formula/multiple functions that can be used to
solve the task at hand? I have looked at the LOOKUP( ) and RANK( )
functions, but did not get very far. I am hoping that there is a way to
match the bowlers' name with the corresponding game score.
Regards,
VinceB.
FYI:
I have updated my Drop Box BVL Summary Trial.ods sheet. Here is the
link to it (I hope that it works this time):
https://www.dropbox.com/s/rtkpz3yl7cqritu/Drop%20Box%20BVL%20Summary%20Trial.ods?dl=0
.
On 3/10/2018 10:57 AM, WA.TWORSX via AOL wrote:
Hi Again:
Well, my previous post
FYI:
I have updated my Drop Box BVL Summary Trial.ods sheet. Here is the
link to it (I hope that it works this time):
https://www.dropbox.com/s/rtkpz3yl7cqritu/Drop%20Box%20BVL%20Summary%20Trial.ods?dl=0
.
On 3/10/2018 10:57 AM, WA.TWORSX via AOL wrote:
Hi Again:
Well, my previous post
Hi Again:
Well, my previous posting failed, due to the formatting not being
carried over in the post. Copy and Paste works okay with a YahooGroup
Mailing List, but not here. So, I am making another attempt to present
my question/problem, and ask for advice and assistance.
(I imagine that th
ssage-
From: Brian Barker [mailto:b.m.bar...@btinternet.com]
Sent: Friday, 8 September 2017 3:33 PM
To: users@openoffice.apache.org
Cc: Mark Messiha
Subject: Re: Error 508 With Open Office When Using Edate Formula
At 04:15 08/09/2017 +, Mark Messiha wrote:
>I have a client who uses Open o
At 04:15 08/09/2017 +, Mark Messiha wrote:
I have a client who uses Open office. I need to
use formula Edate to calculate some dates. When doing so, I get error 508.
The formula is as follows: =edate(r2, 9) or
=edate(r2, 12). Can anyone tell me why I get
error code 508 and what I can do to
All,
I have a client who uses Open office. I need to use formula Edate to calculate
some dates. When doing so, I get error 508.
The formula is as follows: =edate(r2, 9) or =edate(r2, 12). Can anyone tell me
why I get error code 508 and what I can do to fix it?
I have done the following
At 10:38 17/07/2017 +0700, Davy Elias wrote:
I calculating number in column, but the result is different if we
calculate not with the formula
The result is different because you have made mistakes!
I calculate 354.84 x 13,320 the result is 4,726,468.80
... which is exactly correct.
but
On 7/16/2017 11:38 PM, Davy Elias -davyintermedi...@gmail.com wrote:
> Hi ,
>
> I calculating number in column , but the result is different if we
> calculate not with the formula
>
>
> I calculate 354.84 x 13,320 the result is 4,726,468.80
>
> but if w
On 17/07/17 1:38 PM, Davy Elias -davyintermedi...@gmail.com wrote:
Hi ,
I calculating number in column , but the result is different if we
calculate not with the formula
I calculate 354.84 x 13,320 the result is 4,726,468.80
but if we using 354.84 from formula
126.72+3.15- (+25
Hi ,
I calculating number in column , but the result is different if we
calculate not with the formula
I calculate 354.84 x 13,320 the result is 4,726,468.80
but if we using 354.84 from formula
126.72+3.15- (+25%*126.72) + (2.5%* (25%*126.72)) result 98.9820
181.5 + 3.15 -(25%*181.5) +2.5
On 10/16/2016 10:41 PM, Brian Barker wrote:
If you insert rows or columns, formulae containing ranges spanning
those insertions are automatically updated to expand the range. This
is true whether the range appears explicitly or as a name. In other
words, names are also updated appropriately. Th
At 18:23 16/10/2016 +, Vince Bonly wrote:
The formula that appears in C459 contains the text string: $D$343:$L450 .
That's not really a text string in this context but a cell range.
Since the number of rows is increasing over the year, I would like
to name that range and use it
This is a Drop Box link to my (whole nine yards)
spreadsheet:https://www.dropbox.com/s/0l47bmgpwlsx4bo/2016%20My%20Bowling%20Score%20Data.ods?dl=0
I draw your attention to the '2016 Scores sheet, Rows C459 thru C479. The
formula that appears in C459 contains the text string:$D$343:
Thank you.
Regards,
Vince
Sent from my iPad
> On Jun 5, 2016, at 14:17, Dennis E. Hamilton wrote:
>
>
>
>>
>
> In case this remains a question. >100 does not include 100 and <109 does not
> include 109.
>
> So long as the values are integers, >99 and <110 cover 100 to 109 inclusive.
>
> -Original Message-
> From: Vince [mailto:wa.two...@verizon.net]
> Sent: Sunday, June 5, 2016 10:18
> To: users@openoffice.apache.org
> Subject: Re: Search & Replace Formula in Cell with a Named Array
>
> (I reported in an earlier posting, /Detecting/Counting C
Thank you Brian!
On 6/5/2016 2:07 AM, Brian Barker wrote:
Yes. But you won't need to replace the formula, of course, just the
ranges it includes.
In the Find & Replace dialogue, click More Options and select Formulae
in the "Search in" drop-down.
Aha! You're cor
t the number of rows of data within the array will
change each week, as I add additional bowling scores for the week.)
_
Here's my concern: I would appreciate confirmation that the formula:
=SUMPROD
At 13:38 04/06/2016 -0400, Vince Bonly wrote:
Using the Find&Replace feature in AOO 4.1.2 Calc, is it possible to
replace a formula, such as:
=SUMPRODUCT($D$343:$L391>100;$D$343:$L391<109)
with:
=SUMPRODUCT(_2016_Scores_Target_Vince>100;_2016_Scores_Target_Vin
Using the Find&Replace feature in AOO 4.1.2 Calc, is it possible to
replace a formula, such as:
=SUMPRODUCT($D$343:$L391>100;$D$343:$L391<109)
with:
=SUMPRODUCT(_2016_Scores_Target_Vince>100;_2016_Scores_Target_Vince<109)
where:
_2016_Scores_Target_Vince
is a named ar
Dear Alan B,
THANK YOU! It worked beautifully.
Take Care.
Scooter
College Park, MD USA
Alan B wrote on 12/15/2015 6:51 PM:
On Tue, Dec 15, 2015 at 6:01 PM, Scooter C wrote:
I've been trying, in vain, to construct a formula for a time value from
enter times.
I want the minutes or hours
On Tue, Dec 15, 2015 at 6:01 PM, Scooter C wrote:
> I've been trying, in vain, to construct a formula for a time value from
> enter times.
> I want the minutes or hours from a beginning clock time to an ending clock
> time.
> The formula in the help screen: =(c2 right. c2 is
Good Evening Group,
I've been trying, in vain, to construct a formula for a time value from
enter times.
I want the minutes or hours from a beginning clock time to an ending
clock time.
The formula in the help screen: =(c2wasn't right. c2 is the end time, b2 is the start time
Th
Hi,
I am new to this list and have a problem of entering a long mathematical
formula into a text document and subsequently exporting it as PDF.
Basically I like to have a formula e.g.
(a+b)c
be broken up into two lines as follows:
(a
+b)c
I tried via inserting newline in the edit window
At 11:02 08/04/2014 -0500, Don Daugherty wrote:
On 4/7/2014 10:27 AM, J Apples wrote:
When I enter a formula , and get #NAME? for the result, did I do
something wrong?
Maybe the problem is that you simply need to start the formula with
an equal sign, e.g., =IF(A1=B75,"OK";"No
On 4/7/2014 10:27 AM, japples wrote:
When I enter a formula , and get #NAME? for the result, did I do
something wrong?
Maybe the problem is that you simply need to start the formula with an
equal sign, e.g., =IF(A1=B75,"OK";"Not OK"). Just a guess.
---
This email
I entered an "IF" formula that produced the error. Statement of fact.
Not finding an easy answer in Help (opened under OpenOffice Calc, used
"Find" to search the term "#name error" with result "no topics found") -
I turned to the message board (can o
I have NO IDEA who this "japples" is, although I do have your program and wish
I had a manual to look things up
From: Peter Hillier-Brook
To: users@openoffice.apache.org
Sent: Monday, April 7, 2014 9:38 AM
Subject: Re: Calc Formula Question
On 07/
ubject: Re: Calc Formula Question
On 07/04/14 16:27, japples wrote:
> When I enter a formula , and get #NAME? for the result, did I do
> something wrong?
Yes! Did you contemplate looking it up in "Help": the fourth line from the top
takes you to a comprehens
On 07/04/14 16:27, japples wrote:
When I enter a formula , and get #NAME? for the result, did I do
something wrong?
Yes! Did you contemplate looking it up in "Help": the fourth line from
the top takes you to a comprehensive description.
When I enter a formula , and get #NAME? for the result, did I do
something wrong?
: users@openoffice.apache.org
Sent: Wednesday, November 13, 2013 12:09 PM
Subject: Re: essential remark for majority of OO users - incompatibility of
Math formula editor.
e-mail the address you included in the OP
On 11/13/2013 2:46 AM, Yolanda Lowery wrote:
No. It is me that wants to unsub
- incompatibility of
Math formula editor.
e-mail the address you included in the OP
On 11/13/2013 2:46 AM, Yolanda Lowery wrote:
> No. It is me that wants to unsub. Thanks for asking. Please tell me what else
> I need to do.
>
> Thanks,
>
>
>
> Yolanda LaCombe Lowery
>
: Peter Junge
To: users@openoffice.apache.org
Sent: Tuesday, November 12, 2013 8:47 PM
Subject: Re: essential remark for majority of OO users - incompatibility of
Math formula editor.
Yolanda,
are you trying to ask for getting unsubscribed yourself or are you
giving somebody else a hint how to do
: essential remark for majority of OO users - incompatibility of
Math formula editor.
Yolanda,
are you trying to ask for getting unsubscribed yourself or are you
giving somebody else a hint how to do that?
Peter
On 11/13/2013 11:40 AM, Yolanda Lowery wrote:
> users-unsub
From: John Meyer
To: users@openoffice.apache.org
Sent: Tuesday, November 12, 2013 1:27 PM
Subject: Re: essential remark for majority of OO users - incompatibility of
Math formula editor.
On 11/12/2013 2:11 PM, Urmas wrote:
"M. Fioretti":
may I respectfully suggest that a
Math formula editor.
On 11/12/2013 2:11 PM, Urmas wrote:
> "M. Fioretti":
>
> may I respectfully suggest that a former "VP/CIO of IT and Telecom"
> may be expected to know better than highjacking threads on a mailing
> list...
>
> It's just seaso
On 11/12/2013 2:11 PM, Urmas wrote:
"M. Fioretti":
may I respectfully suggest that a former "VP/CIO of IT and Telecom"
may be expected to know better than highjacking threads on a mailing
list...
It's just seasonal relapse.
Not to completely hijack this thread, but I don't think execs at th
"M. Fioretti":
may I respectfully suggest that a former "VP/CIO of IT and Telecom"
may be expected to know better than highjacking threads on a mailing
list...
It's just seasonal relapse.
-
To unsubscribe, e-mail: users-unsubs
12, 2013 12:13:19 PM +0400, svmizin wrote:
>> In other words, what of these two things is the problem:
>>
>> - the formulas generated with the OO formula editor are not readable
>> /editable correctly in MS Office and viceversa
>
> This is THE MAIN problem : MS OF
On Tue, Nov 12, 2013 12:13:19 PM +0400, svmizin wrote:
> >In other words, what of these two things is the problem:
> >
> >- the formulas generated with the OO formula editor are not readable
> > /editable correctly in MS Office and viceversa
>
> This is THE MAI
>On Tue, Nov 12, 2013 10:45:12 AM +0400, svmizin wrote:
>
>> ... this THE ONLY is essential to reject usage of OO for me and many
>> many other potential users: engeneers of all areas and scientists.
>> Please, make a OO compatibility with Microsoft Office "Math formul
What - when did the Internet get hijacked by near-do-wells?
You are one Italian talking to another Italian…
Stop being so damned impudent. Try reading and thinking first.
What the hell so confidential about MS OS blue screening??
About all the bugs over the years in Office - admitted by Bill
What - when did the Internet get hijacked by near-do-wells?
You are one Italian talking to another Italian…
Stop being so damned impudent. Try reading and thinking first.
What the hell so confidential about MS OS blue screening??
About all the bugs over the years in Office - admitted by Bill
On Mon, Nov 11, 2013 23:25:01 PM -0800, Dr Donald Zarlengo wrote:
> Great news. Bu my current major problem on my MacBook Pro...
excuse me, but..
may I respectfully suggest that a former "VP/CIO of IT and Telecom"
may be expected to know better than highjacking threads on a mailing
list (not to m
On Tue, Nov 12, 2013 10:45:12 AM +0400, svmizin wrote:
> ... this THE ONLY is essential to reject usage of OO for me and many
> many other potential users: engeneers of all areas and scientists.
> Please, make a OO compatibility with Microsoft Office "Math formula
> editor"
medium, please
so advise the sender immediately.
On Nov 11, 2013, at 10:45 PM, svmizin wrote:
Dear OO developers.
To save your and my forces and time - at once i say main and THE ONLY reason to
NON-using of OO: its IMcompatibility with Microsoft Office"Math formula e
Dear OO developers.
To save your and my forces and time - at once i say main and THE ONLY reason to
NON-using of OO: its IMcompatibility with Microsoft Office"Math formula editor"!
Really - i am programmer-researcher and physicyst-resercher at www.lebedev.ru.
A
Thanks a lot for the suggestion it
worked out!
BR
On 06/03/2013 01:13 PM, Luis Iglesias wrote:
Hi.
The problem is not with fractions but with the values you expect
in your conditional. Your formula only
Hi.The problem is not with fractions but with the values you expect in your conditional. Your formula only applies when A23 < B9 or when A23 = (1,2,3,4,5,6,7,8). You can fix in your last IF:...IF(A23=8;$F$16;1)...or maybe you're looking for something like:=IF(A23<$B$9;$F$8;IF(A23>8;
Hello,
I'm having a problem with a formula that i have
=IF(A23<$B$9;$F$8;IF(A23=1;$F$9;IF(A23=2;$F$10;IF(A23=3;$F$11;IF(A23=4;$F$12;IF(A23=5;$F$13;IF(A23=6;$F$14;IF(A23=7;$F$15;IF(A23=8;$F$16)*A23*D23
If the content of A23 is integer the formula works fine, but if the
conten
90 matches
Mail list logo
