Double if

[TRS]

Hi guys,

I hope you can help me.

now I have this formula

=IF(B2>1,1,0)

but I discovered there is another paramiter that I have to consider. Basically if A2=Y this formula is still valid. If A2=N the formula should be =IF(B2>2,1,0)
Should be something like what I have written below. I have also attached a file. Maybe it helps.

IF A2=Y THEN C2="IF(B2>2,1,0)"
IF A2=N THEN C2="IF(B2>1,1,0)"

Let me know if something is not clear.
Thanks in advance for your help!!!

[Andrew-R]

How about:

=IF(B2>IF(A2="Y",1,IF(A2="N",2,0)),1,0)

[NBVC]

Possibly?

=IF(A2="Y",IF(B2>2,1,0),IF(B2>1,1,0))

[TRS]

yes! great it works. Much appreciated ))

I am posting another question in a different thread. That one is more difficult. I hope you can help me also there

anyway THANKS FOR HELPING here!