+ Reply to Thread
Results 1 to 2 of 2

Add to an existing formula

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Add to an existing formula

    Hello to all,
    this formula:

    in italian:

    =SE($B$2="";"";SE(CONTA.SE($A$6:$A$206;"*"&$B$2&"*")=1;"trovato "&CONTA.SE($A$6:$B$206;"*"&$B$2&"*")&" articolo";
    SE(CONTA.SE($B$6:$B$206;"*"&$B$2&"*")=1;"trovato "&CONTA.SE($B$6:$B$206;"*"&$B$2&"*")&" descrizione";
    SE(CONTA.SE($A$6:$A$206;"*"&$B$2&"*")>1;"trovato "&CONTA.SE($A$6:$B$206;"*"&$B$2&"*")&" articoli";
    SE(CONTA.SE($B$6:$B$206;"*"&$B$2&"*")>1;"trovato "&CONTA.SE($B$6:$B$206;"*"&$B$2&"*")&" descrizioni";
    "nessun articolo/descrizione trovato")))))

    in english:

    =IF($B$2="","",IF(($A$6:$A$206,"*"&$B$2&"*")=1,"found "&COUNTIF($A$6:$B$206,"*"&$B$2&"*")&" article",
    IF(COUNTIF($B$6:$B$206,"*"&$B$2&"*")=1,"found "&COUNTIF($B$6:$B$206,"*"&$B$2&"*")&" description",
    IF(COUNTIF($A$6:$A$206,"*"&$B$2&"*")>1,"found "&COUNTIF($A$6:$B$206,"*"&$B$2&"*")&" articles",
    IF(COUNTIF($B$6:$B$206,"*"&$B$2&"*")>1,"found "&COUNTIF($B$6:$B$206,"*"&$B$2&"*")&" descriptions",
    "no found article/descritions")))))

    The change is:
    example:
    in column A = hello
    in column B = hello
    in B3 = hello
    in B2 = found 1 article / found 1 description
    I hope I explained me.
    max_max
    -------------------------------------------------------------------------------------------------------------
    Ciao a tutti,
    questa formula:

    in italiano:

    =SE($B$2="";"";SE(CONTA.SE($A$6:$A$206;"*"&$B$2&"*")=1;"trovato "&CONTA.SE($A$6:$B$206;"*"&$B$2&"*")&" articolo";
    SE(CONTA.SE($B$6:$B$206;"*"&$B$2&"*")=1;"trovato "&CONTA.SE($B$6:$B$206;"*"&$B$2&"*")&" descrizione";
    SE(CONTA.SE($A$6:$A$206;"*"&$B$2&"*")>1;"trovato "&CONTA.SE($A$6:$B$206;"*"&$B$2&"*")&" articoli";
    SE(CONTA.SE($B$6:$B$206;"*"&$B$2&"*")>1;"trovato "&CONTA.SE($B$6:$B$206;"*"&$B$2&"*")&" descrizioni";
    "nessun articolo/descrizione trovato")))))

    in inglese:

    =IF($B$2="","",IF(($A$6:$A$206,"*"&$B$2&"*")=1,"found "&COUNTIF($A$6:$B$206,"*"&$B$2&"*")&" article",
    IF(COUNTIF($B$6:$B$206,"*"&$B$2&"*")=1,"found "&COUNTIF($B$6:$B$206,"*"&$B$2&"*")&" description",
    IF(COUNTIF($A$6:$A$206,"*"&$B$2&"*")>1,"found "&COUNTIF($A$6:$B$206,"*"&$B$2&"*")&" articles",
    IF(COUNTIF($B$6:$B$206,"*"&$B$2&"*")>1,"found "&COUNTIF($B$6:$B$206,"*"&$B$2&"*")&" descriptions",
    "no found article/descritions")))))

    La modifica è:
    esempio:
    nella colonna A = ciao
    nella colonna B = ciao
    in B3 = ciao
    in B2 = trovato 1 articolo / trovato 1 descrizione.
    Spero di avermi spiegato.
    max_max
    Last edited by max_max; 11-06-2013 at 04:06 PM. Reason: traslation incorrect

  2. #2
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: Add to an existing formula

    Hello to all,
    perhaps I have not explained properly?
    max_max
    ----------------------------------------------
    Ciao a tutti,
    forse non mi sono spiegato correttamente?
    max_max

+ 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. Replies: 11
    Last Post: 11-04-2013, 04:32 PM
  2. Replies: 3
    Last Post: 10-14-2013, 03:06 PM
  3. [SOLVED] Formula for line numbers to change with existing formula
    By Vmgballer1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2013, 09:36 AM
  4. Replies: 0
    Last Post: 03-13-2013, 12:25 PM
  5. Replies: 3
    Last Post: 09-07-2012, 12:07 AM

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