AND Function

[johankotze]

I tried to get a value in a cell that depend on the info in two cells in a worksheet but can't get it to work.

=IF('Alg. Inligting & DO'!I10="Mutaul & Federal" AND 'Alg. Inligting & DO'!D40="Ja",0,6)

[meyero90]

hi,
Can you send it in an attachment?

[wamp]

Set the "and" statement first within the if-statement.
I would assume your code should be like this:
=IF(AND('Alg. Inligting & DO'!I10="Mutaul & Federal",'Alg. Inligting & DO'!D40="Ja"),0,6)









_______________________________________________
Hope this helps

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of their post to show your appreciation.

[Marcol]

Try this

=IF(AND('Alg. Inligting & DO'!I10="Mutaul & Federal", 'Alg. Inligting & DO'!D40="Ja"),0,6)

Cheers

[Richard Buttrey]

Hi,

That And structure is the way Lotus 123 handled it. Try instead:

Please Login or Register  to view this content.

HTH

[wamp]

[removed - mild dyslexia, reading error :-p]

[johankotze]

Thanx wamp and Marcol it works great. The quickest reply I ever experience. Thanx guys

[johankotze]

Thanx Richard. Must say it's along time ago when I did some programming in Excel. Thanx alot for the reply