+ Reply to Thread
Results 1 to 3 of 3

Formula from openoffice calc to excel

Hybrid View

matmax54 Formula from openoffice calc... 01-21-2014, 02:45 AM
vlady Re: Formula from openoffice... 01-21-2014, 03:11 AM
matmax54 Re: Formula from openoffice... 01-21-2014, 10:38 AM
  1. #1
    Registered User
    Join Date
    01-17-2014
    Location
    minneapolis, mn
    MS-Off Ver
    Excel 2010
    Posts
    2

    Formula from openoffice calc to excel

    First, Hello everybody and thank you for all the work and help you are giving on this forum.

    In my company, we used to work with openoffice document but we upgraded and I have know access to excel only, which is pretty nice but it takes some time to adapt and learn how it works. anyway... I am stuck with a formula on calc:

    =SI(NB.SI('1_Vocabulaire'!B3:D3,"A")>0,NB.SI('1_Vocabulaire'!B3:D3,"A"),SI(NBVAL('1_Vocabulaire'!B3:D3)>0,"X",""))

    I have several pages on my document:
    One page named "1_Vocabulaire" if in this page, in the cells B3, C3 and D3 there is a "A" I would like the cell to display the number of "A" in cells B3, C3 and D3.
    If it is empty in B3 C3 and D3, no display.
    If there is no "A", but some "X" display "0"

    I would like this formula to be able to work on excel.

    Thank you in advance for your huge Help
    I am available for any questions or if you need any information.

    PS: sorry for my English, I am French but I live in the US.

    Matmax54

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Formula from openoffice calc to excel

    using this link
    http://mymemory.translated.net/t/Fre...ish/nbval%20si

    =IF(countif('1_Vocabulaire'!B3:D3,"A")>0,countif('1_Vocabulaire'!B3:D3,"A"),if(counta('1_Vocabulaire'!B3:D3)>0,"X",""))

    i'm on the other side of the globe so not sure on the language.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    01-17-2014
    Location
    minneapolis, mn
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Formula from openoffice calc to excel

    thank you vlady but it doesn't seem to be that simple because after translating the words, I think the structure of the formula should change a bit... I think...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel formula in Openoffice
    By Bbongo8 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2012, 04:40 AM
  2. run OpenOffice & Excel
    By Geordie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2010, 01:15 AM
  3. Excel 2007 : OpenOffice & Excel
    By Geordie in forum Excel General
    Replies: 2
    Last Post: 05-06-2010, 02:58 PM
  4. OpenOffice & Excel VBA
    By Baapi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2009, 07:26 AM
  5. [SOLVED] How can I open an OpenOffice spreadsheet in Excel?
    By GSavage in forum Excel General
    Replies: 2
    Last Post: 04-12-2006, 12:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1