Formula Help!!

[Guest]

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

 

[Guest]

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

 

[Guest]

Thanks.
I'd actually got that far, the problems start when I try to incorporate the
other cells.
So cell AM1 needs to say registration if any of S1, U1 or AL1 is blank and
also if Q1 and R1 is blank.

 

[Guest]

That makes it a bit more complicated but with OR and AND operators you can do
a lot :

In this case I would use =
If(OR(S1="";U1="";AL1="";AND(Q1="";R1=""));"Registration";"")

Test if it gives the desired result. If you need to change the logic, search
the HELP for AND an OR operators to learn how these work.

Good luck !

Hans

 

[Guest]

Thanks so much - it works!

That makes it a bit more complicated but with OR and AND operators you can do
a lot :

In this case I would use =
If(OR(S1="";U1="";AL1="";AND(Q1="";R1=""));"Registration";"")

Test if it gives the desired result. If you need to change the logic, search
the HELP for AND an OR operators to learn how these work.

Good luck !

Hans