Wrong formula?

[Tom_Brinkmann_1961]

I could really use some help with follwing formula:
=ALS(EN(F92>4000;F92<5000);$B$91)(EN(F92<4000);$B$94;$B$93) (dutch)
=IF(AND(F92>4000;F92<5000);$B$91)(AND(F92<4000);$B$94;$B$93) (English)

It results in an error message as if F92 is removed (which is not the case) #VERW! (dutch)

Where did I go wrong in this?
Thanks in advance for any help!

Best regards
Tom

[#2 · Accepted solution]

@Tom_Brinkmann_1961 

Use

=ALS(F92<4000;$B$94;ALS(F92<5000;$B$93;$B$91))

[#3]

@Hans Vogelaar 

thanks for your quick reply Hans,
I had to insert it in my spreadsheet several times before it properly worked, but now it does!

Thanks so much for helping me out!

Best regards,
Tom