If False then (another formula)

[Kirstym1918]

Hi all,

How do I add to this formula =IF(COUNTIF(Monday!$G$6:$I$25,$B2)>0,"W","")

It looks in the Monday range for a match with B2 then returns "W" but if false I would like it to carry out another formula to find a match but return R as per below, any idea how I can do this.
=IF(COUNTIF(Monday!$T$6:$U$31,$B2)>0,"R","")

Many Thanks

 

[mikerickson]

Hi all,

How do I add to this formula =IF(COUNTIF(Monday!$G$6:$I$25,$B2)>0,"W","")

It looks in the Monday range for a match with B2 then returns "W" but if false I would like it to carry out another formula to find a match but return R as per below, any idea how I can do this.
=IF(COUNTIF(Monday!$T$6:$U$31,$B2)>0,"R","")

Many Thanks

Those two formulas are testing the same condition.
If B2 is in the Monday! range you want "W"
What do you want if B2 is not in the Monday! range?

 

[gaz_chops]

I just tested & they work fine! if it doesn't find B2 in G6:I25 it checks T6:U31 & returns W
@mikerickson Monday is the sheet name.

 

[Kirstym1918]

They do yes, its driving me insane ha ha!

 

[gaz_chops]

If it is returning a Space then it is not finding B2 in either range, are you certain it appears, if so what is in B2?

 

[Kirstym1918]

Those two formulas are testing the same condition.
If B2 is in the Monday! range you want "W"
What do you want if B2 is not in the Monday! range?

Hi Mike,

Basically the Monday tab is a plan with employee names on, if their name is in Monday!G6:I25 then I want it to return W (working), If they are not working they will be in the Monday!T6:U31 range which would return R (Rest Day)

Regards

 

[gaz_chops]

If you think B2 does appear in 1 of the ranges, then i would suggest that what is in B2 isn't exactly the same as what appears in the 2 ranges!
Are there any spaces, extra characters etc?

You can check by entering =B2=Monday!??
change ?? to be the cell that you believe matches.

 

[Kirstym1918]

Guys, It was me being a dim wit, It works perfectly.

Thank you so much

 

[gaz_chops]

You're welcome, glad you got it working.