Forum Discussion
Solved
Need help with formula
I am trying to expandthe following formula to multiple sheets, but when I try the function stops working and always displays a Y. =IF(ISBLANK('Qtr 1'!C4),"","Y") Basic goal is to search throu...
A simple solution.
=IF((('Qtr 1'!C4)<>"")+('Qtr 2'!C4)<>"")+('Qtr 3'!C4)<>"")+('Qtr 4'!C4)<>""))>0,"Y","")Untested.
A simple solution.
=IF((('Qtr 1'!C4)<>"")+('Qtr 2'!C4)<>"")+('Qtr 3'!C4)<>"")+('Qtr 4'!C4)<>""))>0,"Y","")Untested.
I had to update the parenthesis, but this did the trick. Thanks!
=IF(((('Qtr 1'!C4)<>"")+(('Qtr 2'!C4)<>"")+(('Qtr 3'!C4)<>"")+(('Qtr 4'!C4)<>""))>0,"Y","")
=IF(((('Qtr 1'!C4)<>"")+(('Qtr 2'!C4)<>"")+(('Qtr 3'!C4)<>"")+(('Qtr 4'!C4)<>""))>0,"Y","")