Formula Problem

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

Hi,
I am confused.................?


Try:

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

sambit said:

Hi,
I am confused.................?


Try:

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

Click to expand...

Thanks,

It works a treat. Really appreciate your help.