Results 1 to 3 of 3

Thread: Formula Problem

  1. #1

    Formula Problem



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

    I am trying to get a formula to look at 2 conditions and select a cell with a value in it and then repeat the exercise for a different set of conditions and then select a different cell with a value in it.

    Logically the formula seems to work but the answer I get is "#VALUE!". Are you able to advise where I a going wrong please.


    Formula: =IF(AND(OR(G6="dale",I6="y"))J6,L6),IF(AND(OR(G6="dale",I6="n")),K6,L6)

    I6= 10, K6= 20, L6= 0

    Answer: #VALUE!

    Daleh

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    I am confused.................?


    Try:

    =IF(AND(G6="dale",I6="y"),J6,IF(AND(G6="dale",I6="n"),K6,L6))

  3. #3

    Smile

    Quote Originally Posted by sambit View Post
    Hi,
    I am confused.................?


    Try:

    =IF(AND(G6="dale",I6="y"),J6,IF(AND(G6="dale",I6="n"),K6,L6))
    Thanks,

    It works a treat. Really appreciate your help.

Posting Permissions

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