•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
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives
#score sheet
#IF
#AND
#blank cell
#world cup
#J2
#L2
#cells empty
#F2
#equation
#H2
#return empty
#points