Results 1 to 8 of 8
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    simple formula... (2000 sr-1)

    if I3="no" and J3="no" then "ok" else ""
    not work!!!
    =SE(I3="NO"+E(SE(J3="NO";"OK";"")))

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: simple formula... (2000 sr-1)

    E is a function, just like SE. You must use

    E(I3="NO",J3="NO")

    The total formula becomes

    =SE(E(I3="NO",J3="NO"),"OK","")

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: simple formula... (2000 sr-1)

    Hi Hans

    <E is a function, just like SE. You must use>

    Out of pure curiosity what are these functions?

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: simple formula... (2000 sr-1)

    Sal21 posted a formula from the Italian language version of Excel. E is Italian for AND, and SE is Italian for IF.

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: simple formula... (2000 sr-1)

    Hi Hans

    Now I now why they say curiosity killed the cat!. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: simple formula... (2000 sr-1)

    Don't worry Braddy, I was wondering too but I was too shy to ask <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  7. #7
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: simple formula... (2000 sr-1)

    =SE(E(I3="NO",J3="NO") , "OK","")

    I have modified , with ;

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: simple formula... (2000 sr-1)

    That depends on your system settings - if you use a comma as decimal separator, you must use a semi-colon ; as list separator, and if you use a point as decimal separator, you must use a comma as list separator.

Posting Permissions

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