+ Reply to Thread
Results 1 to 3 of 3

excel formula question

  1. #1
    k.vangeffen
    Guest

    excel formula question

    Hello,

    Question:
    I've got this formula; =OR(AND(E2-G2>1000;E2-H2>500);(AND(G2=0;H2=0)))
    And it works great, the problem is I do not want the true or false
    answer but want to personalize it.
    As far as I get it I need to put at the end of the formula someting
    like; (, "ok", "to big")
    What ever, the answer is in dutch so it wouldn't help you a lot..
    Can comeone please help me??

    Regards,

    Krien

  2. #2
    Niek Otten
    Guest

    Re: excel formula question

    Hi Krien,

    =IF(OR(AND(E2-G2>1000,E2-H2>500),(AND(G2=0,H2=0))),"VooruitDanMaar","Te
    Heftig")


    --
    Kind regards,

    Niek Otten

    "k.vangeffen" <krienv@yahoo.com> wrote in message
    news:be23d$43cbe028$50381751$15860@news.chello.nl...
    > Hello,
    >
    > Question:
    > I've got this formula; =OR(AND(E2-G2>1000;E2-H2>500);(AND(G2=0;H2=0)))
    > And it works great, the problem is I do not want the true or false answer
    > but want to personalize it.
    > As far as I get it I need to put at the end of the formula someting like;
    > (, "ok", "to big")
    > What ever, the answer is in dutch so it wouldn't help you a lot..
    > Can comeone please help me??
    >
    > Regards,
    >
    > Krien




  3. #3
    k.vangeffen
    Guest

    Re: excel formula question

    Hi Niek,

    Yep it works!
    Thanks a lot

    Niek Otten wrote:
    > Hi Krien,
    >
    > =IF(OR(AND(E2-G2>1000,E2-H2>500),(AND(G2=0,H2=0))),"VooruitDanMaar","Te
    > Heftig")
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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