hello every body.
I've written a code in my excel.Now I want to write such formule in access too.how can i write this "if" statement in access?
=IF(AND(F11=8484,OR(G11=20,G11=21)),8470,IF(AND(F11=8484,OR(G11=40,G11=41)),8472,F11))
each cell in the above formule reffers to a field in my table...