IF/ AND problem

[Higgy]

PLease forgive the informality of this enquiery, but I am new to this.
Can anyone assist with the following;
I can get both of the below formulas to work individually,
=IF(AND(B3=3,C3="Y"),"WARNING","")
=IF(AND(B3=1,C3="N"),"WARNING","")
but would like to combine them to get the same result (if that makes sence).
Something like
=IF(AND(B3=3,C3="Y"),(B3=1,C3="N"),"WARNING","")
Any offers??

[zbor]

Wellcome to the forum.

Please, rename your thread according to the rules

(Hint: be more descriptive about your problem, avoid help, please etc words)

[t_e_k]

=IF(OR(AND(B3=3,C3="Y"),AND(B3=1,C3="N")),"WARNING","")

Gives WARNING if either of the two sets of conditions are true.

[DonkeyOte]

t_e_k, just as a heads up as I know you are new to the board - as a rule if a request is made to OP in regard to them failing to comply with Forum Rules (be that request made by a Mod or non-Mod) we ask no further posts on the thread until such time as the OP complies with the request(s)

As you're aware this is a Moderated Forum, as such Infractions are handed out to members as and when the Forum rules are ignored - the Rules are there to benefit all (so as to standardise the look and feel of the posts etc and ensure the search functionality is as effective as possible etc...)
Needless to say a build of Infractions will lead to Bans (temp/perm).

[Higgy]

Sorry! However did say I was new to this. NO insult intended will change title in accordance with THE RULES and wont do it again.

[DonkeyOte]

Yes, please do so (given it was your first post no Infraction/Warning was given on this occasion).

Until such time as the title is revised per the rules no further posts are to be made on this thread.

[Higgy]

t_e_k
Thanks owe you one!
Higgy

[Higgy]

Does THIS meet with your requirements?

[DonkeyOte]

It'll do

Given we are on the subject of rules etc (there are a lot!) - we generally also ask you mark the thread as Solved as and when you have completion, to do so:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save