USE IF(AND(...... to check values in dropdown list...

[espenskeie]

Hi

Can anyone help me on how to use the =IF(AND(.... to check what values that are selected from the dropdown lists and then Return correct cell value?

This is my formula:

=IF(AND(E4="USD";G4="Free");Cash!E25;
IF(AND(E4="USD";G4="Restr.");Cash!E35;
IF(AND(4="NOK";G4="Free");Cash!E5;
IF(AND(E4="USD";G4="Free");Cash!E15;
"ERR"))))

Brgds
Espen

 

[espenskeie]

Maybe i should check my formula NeXT time....


now it Works:

=IF(AND($E$4="USD";$G$4="Free");Cash!E25;
IF(AND($E$4="USD";$G$4="Restr.");Cash!E35;
IF(AND($E$4="NOK";$G$4="Free");Cash!E5;
IF(AND($E$4="NOK";$G$4="Restr.");Cash!E15;
"ERR"))))