Formula Help!!
 

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

Formula Help!!
 

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

Formula Help!!
 

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.

"hans bal(nl)" wrote:

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

Formula Help!!
 

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=""));"Regist ration";"")

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


"Becksicle" wrote:

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.

"hans bal(nl)" wrote:

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

Formula Help!!
 

Thanks so much - it works!

"hans bal(nl)" wrote:

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=""));"Regist ration";"")

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


"Becksicle" wrote:

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.

"hans bal(nl)" wrote:

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