Nested IF, AND, OR

[tonybr]

Having trouble getting this to work so would appreciate some advice on the syntax please.

My question is basically IF the string in cell C1 = "Relief Refuse Driver" and either cell J1 OR cell K1 (or both) are not empty, then do AA or else do AB.

The last bit isn't a problem, it's where to put the OR.

The fomula I am using in Cell G1 does as I want but I am unsure where to put the OR K1:

=IF(AND(C1="Relief Refuse Driver",J1<>""),(Grades!$B$16),(VLOOKUP(F15,'All Staff'!$A$4:$K$107,11,FALSE)))

Thanks in advance.

Tony

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=IF(AND(C1="Relief Refuse Driver",OR(J1<>"",K1<>"")),Grades!$B$16,VLOOKUP(F15,'All Staff'!$A$4:$K$107,11,FALSE))

 

[tonybr]

Yes that's done the job thank you.

 

[Fluff]

You're welcome & thanks for the feedback.