Using IF AND OR

Hi all,

It's Friday night and I'm stuck with what should be a simple formula, someone please put me out of my misery

I'm trying to use IF AND OR in one formula to get one of 2 outcomes, here's what I've got:

=IF(AND(AQ7="N",AN7<0,OR(AND(AQ7="Y",AN7>0))),AN65,"Positive Interest - No Charge to Client")

basically two conditions
1) if cell = N and less than 0 I want the cell value AN65 to appear or that condition is not met then display text "Positive Interest - No Charge to Client"
2) if cell = Y and more than 0 I want the cell value AN65 to appear or that condition is not met then display text "Positive Interest - No Charge to Client"

have I missed something? it must be an easy fix.... I'm blaming it on Friday night brain freeze!!!

Hi & welcome to the board.
Try it like

Formula:

Please Login or Register  to view this content.

Works! Thanks Fluff13 your a legend

Glad to help & thanks for the feedback.