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 through 4 quarter sheets for the year and then return a "Y" if there is any data available and nothing "" if there is none.
A simple solution.
=IF((('Qtr 1'!C4)<>"")+('Qtr 2'!C4)<>"")+('Qtr 3'!C4)<>"")+('Qtr 4'!C4)<>""))>0,"Y","")Untested.
3 Replies
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","")
