If A1 = the cell taht you want to test use the formula: =
if(A1="";"Registration";"")


"Becksicle" wrote:

Hi ,

Can someone please help me?
If certain cells are not blank I would like "Registration" to appear in my
cell
I have tried various combinations or OR, AND, IF, ISBLANK....and many more.
I think I'm over complicating this though.

Basically if any of (Q or R) and S and U and AL are all not blank, my
criteria are met.
So I need data to be in columns, S, U, AL and either Q or R. If these
criteria are met, the cell needs to say Registration.

Can anyone help?

Thanks Becki