Re: Excel formula tool tip suggestion to match Microsoft's feature

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't visit here

Excel formula tool tip suggestion to match Microsoft's feature

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...

Re: Formula construction help

SED 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 otherwise. No long

Re: Formula construction help

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 first place.

Re: Formula construction help

ice 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 formula... that

Re: Formula construction help

o 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 kno

Re: Formula construction help

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

Re: Formula construction help

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

Re: Formula construction help

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". >>>> >>&g

Re: Formula construction help

 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 knowing how to construct 

Re: Formula construction help

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 knowing how t

Re: Formula construction help

n 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. -

Formula construction help

eport "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-mail: users-un

Re: Incorrect formula of function RECEIVED.

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

Re: Incorrect formula of function RECEIVED.

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 / day

Re: Incorrect formula of function RECEIVED.

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 think tha

Re: Incorrect formula of function RECEIVED.

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

Incorrect formula of function RECEIVED.

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 Formulas

Re: Formula

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 helpful to place

Re: Formula

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,

Re: Formula

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

Formula

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

Ignoring a divide by zero error in Writer table formula

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

Re: add formula to cell in openoffice spreadsheet

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

add formula to cell in openoffice spreadsheet

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 versions and libreoffice until ver

Re: Spreadsheet Formula Hiding "0"

ot; 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 Cell contains a formula. ( I appreciate that th

Re: Spreadsheet Formula Hiding "0"

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 Cell c

Spreadsheet Formula Hiding "0"

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 when t

edit a formula

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:

Re: edit a formula

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)+(b4*e4)+(a5*e5)+(a6*e6)+(a7

edit a formula

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 change 'e' for 'b

Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

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,

Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

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

Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

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,

Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

t 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 formula

Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

arch 15, 2018 8:18 AM > 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 l

Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

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 with Results

Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

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 looked

Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

. 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.

Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

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

Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

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

Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

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

RE: Error 508 With Open Office When Using Edate Formula

- 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 <mark.mess...@wentwest.com.au> Subject: Re: Error 508 With Open Office When Using Edate Formula At 04:15 08/09/2017 +, Mark Messiha wrote: &

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 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

Error 508 With Open Office When Using Edate Formula

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

Re: Calculating in column with the formula -Error

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

Re: Calculating in column with the formula -Error

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

Re: Calculating in column with the formula -Error

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

Calculating in column with the formula -Error

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

Re: Naming a String that appears within a Calc formula

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.

Re: Naming a String that appears within a Calc formula

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

Naming a String that appears within a Calc formula

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:$L450

Re: Search & Replace Formula in Cell with a Named Array

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

RE: Search & Replace Formula in Cell with a Named Array

> -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/Countin

Re: Search & Replace Formula in Cell with a Named Array

At 13:38 04/06/2016 -0400, Vince Bonly wrote: Using the Find 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_

Search & Replace Formula in Cell with a Named Array

Using the Find 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 array

Re: Problem with Calc formula

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 <scoo...@scootersdesk.com> wrote: I've been trying, in vain, to construct a formula for a time value from enter times.

Problem with Calc formula

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: =(c2<b2)+ c2-b2. I tried it but it wasn't right. c2 is the end time,

Re: Calc Formula Question

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 is free from viruses

Re: Calc Formula Question

AM Subject: 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 comprehensive description. Peter HB

Re: Calc Formula Question

who this japples is, although I do have your program and wish I had a manual to look things up From: Peter Hillier-Brook p...@hbsys.plus.com To: users@openoffice.apache.org Sent: Monday, April 7, 2014 9:38 AM Subject: Re: Calc Formula Question On 07/04/14

Re: essential remark for majority of OO users - incompatibility of Math formula editor.

johnme...@pueblocomputing.com To: 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

Re: essential remark for majority of OO users - incompatibility of Math formula editor.

: Peter Junge peter.ju...@gmx.org 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

Re: essential remark for majority of OO users - incompatibility of Math formula editor.

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. Thanks for asking. Please tell me what else I need to do. Thanks,   Yolanda LaCombe Lowery Glendale

Re: Re: essential remark for majority of OO users - incompatibility ofMath formula editor.

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 - first priority level

Re: Re: essential remark for majority of OO users - incompatibility ofMath formula editor.

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 MAIN problem : MS OFFICE document formulas don

Re: essential remark for majority of OO users - incompatibility ofMath formula editor.

wrote: 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 MAIN problem : MS OFFICE document formulas

Re: essential remark for majority of OO users - incompatibility of Math formula editor.

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:

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 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 that

Re: essential remark for majority of OO users - incompatibility of Math formula editor.

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 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

Re: essential remark for majority of OO users - incompatibility of Math formula editor.

From: John Meyer johnme...@pueblocomputing.com 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

essential remark for majority of OO users - incompatibility of Math formula editor.

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 OfficeMath formula editor! Really - i am programmer-researcher and physicyst-resercher at www.lebedev.ru. All my work

Re: essential remark for majority of OO users - incompatibility of Math formula editor.

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

Essential remark for majority of OO users - incompatibility of Math formula editor. OO organized hijack of test, spread sheet etc. software...

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

Essential remark for majority of OO users - incompatibility of Math formula editor. OO organized hijack of test, spread sheet etc. software...

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

Re: Problem with a formula

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(A238;$F$16;IF(A237;$F