•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Addition required to make blank if cells empty
Hi I have the following equation for a score sheet based on world cup results.
=IF(AND(F2=J2,H2=L2),6,(F2=J2)+(H2=L2)+AND(J2>L2,F2>H2)+AND(J2=L2,F2=H2)+AND(J2<L2,F2<H2))
However when all cells are blank currently the result is giving 6 points. I'm after an addition to this equation that would make the cell blank if one or both J2 and L2 are blank that it would return a empty/blank cell itself?
[link] [comments]
Want to read more?
Check out the full article on the original site