Excel question

[sjaak1943]

I need one trigger with following items:

IF "A" AND "B" = true "LAY", not true "do nothing"
IF "C" AND "D" = true "BACK", not true "do nothing"

Thanks, I could not do it!

Sjaak

[Ian]

What happens if a,b,c,d are all true ?

[sjaak1943]

Hello Ian.

It can't be.
B=7 and D=8.
Both come from the same cell, sum of conditions.

Sjaak

[Ian]

Do you mean IF A = B then LAY , IF C = D then BACK ?

[sjaak1943]

Hello Ian,

First part of the trigger, works perfect on his own:
=IF(AND($B$57=F5,$D$60=7),"LAY-F1","no signal")

Second part of the trigger, works perfect on his own:
=IF(AND($B$59=F5,$D$60=8),"BACK","no signal")

I want them in one trigger.

Sjaak

[Ian]

Try this .....

=IF(AND($B$57=F5,$D$60=7),"LAY-F1",IF(AND($B$59=F5,$D$60=8),"BACK","no signal"))

[sjaak1943]

A bracket was missing.
I have this now:

=IF(AND($B$57=F5,$D$60=7),"LAY-F1",no signal),IF(AND($B$59=F5,$D$60=8),"BACK","no signal")

I had this before, still gives an error "VALUE".

[Ian]

This is the formula - the smilies were messing it up ...

=IF(AND($B$57=F5,$D$60=7),"LAY-F1",IF(AND($B$59=F5,$D$60=8),"BACK","no signal"))

[sjaak1943]

Hello Ian,

No errors anymore, testing it now.
Thank you for your time.

Sjaak