#DIV/0! Error Help

[L.J.]

Hello, I have a spreadsheet I'm working on that I'd like help suppressing the #DIV/0! Error on.

my formula is =SUM(B19:I19)/F2

My formula works great so long as F2 is populated. However on a new blank doc I get that error and it just looks ugly and I'd much prefer it to return 0 if F2 is 0 or unpopulated.

Any help making my sheet look boss would be greatly appreciated.

Please, and thank you.

[TMS]

Try

Please Login or Register  to view this content.