Results 1 to 4 of 4

Thread: converting true and false to yes and no

  1. #1

    converting true and false to yes and no



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello all, can anyone help me as to where I put "YES","NO" in the following formula as wherever is try to put it in with the IF function it shows an error? =OR(AND(D6=Sheet2!B4,Sheet1!D8=Sheet2!D4,Sheet1!D10=Sheet2!F3,Sheet1!D12=Sheet2!H3),(AND(D6=Sheet2!B4,Sheet1!D8=Sheet2!D4,Sheet1!D10=Sheet2!F3,Sheet1!D12=Sheet2!H4)))

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Perhaps = IF(your_formula,"YES","no")

  3. #3
    unfortunately this doesn't work, I cannot work out which order the IF, OR & AND function need to be in in order for it to return yes or no

  4. #4

Posting Permissions

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