Formula query
 

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.

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.

--
Andy.


"Gailwdz" wrote in message
...
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.

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

"Andy B" wrote:

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.

--
Andy.


"Gailwdz" wrote in message
...
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.