IF(AND Formula is return #VALUE!

[katieshields]

Please can another genius help me formulas. I have a IF formula as I need to show if something is authorised or not. Cell K33 is the Amount which needs to be authorised and Cell D47 is the position of the person authorising. I am using IF to show if the position inserted have an authorisation to cover the amount.

The formula I have used so far is

=IF(AND(D47=G45,K33<K45+0.01),"Authorised","Not Authorised"),IF(AND(D47=G47,K33<K47+0.01),"Authorised","Not Authorised")

The first calculation worked so I continued for the 2nd one, this is when I got the #VALUE! return.

Thanks

Katie

[Pepe Le Mokko]

Try =IF(OR(AND(D47=G45,K33<K45+0.01),AND(D47=G47,K33<K47+0.01)),"Authorised","Not Authorised")