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
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