Solved: Formula gone wrong

[khalid79m]

=IF(Call_Data_Input_Check&Score_Input_Check="PP","TRUE","FALSE")


the range Call_Data_Input_Check & Score_Input_Check = "PP" so it show true but it shows false..

any suggestionjs

[AZIQN]

It's not apparent what is going wrong with the formula by your description. Can you upload a copy of the the workbook?

[Bob Phillips]

How can you use an & in a range name?

If you want if any of those cells contains PP use

=COUNTIF(rng,"PP")>0

[AZIQN]

I think he has "Call_Data_Input_Check" and "Score_Input_Check" as two separate cell ranges, each with the letter P. Then they are concatenated in the IF statement's logic test using the "&"...

[khalid79m]

I cracked it, my sheet had an error elswhere hence causing this to mess up :banghead: