Formula query

[Guest]

How do I create a formula where the value of one cell is dependent on the
value of two other cells? This formula would form part a nested if function.

 

[Guest]

Hi
You might need an OR or AND formula. You don't say how the cell is dependent
on the other cells, though.
=IF(OR(A2="Y",A3="Y"),"Y","N")
will check if A2 or A3 = "Y" and then return a "Y" if true
=IF(AND(A2="Y",A3="Y"),"Y","N")
will check if A2 and A3 = "Y"
Hope this helps.

 

[Guest]

I think the and function should do it - thanx Andy.