Microsoft Office Forums - View Single Post - IF statments

Thread: IF statments

View Single Post

Old

07-19-2017, 08:37 AM

Tye Rogers Tye Rogers is offline

Tye Rogers is offline

Tye Rogers uses Windows 10

Windows 10 Tye Rogers uses Office 2016

Tye Rogers uses Office 2016

Office 2016

Novice

The original poster

Join Date: Jul 2017

Posts: 1

Tye Rogers is on a distinguished road

Default

IF statments

I am getting #DIV/0! in a cell.
=IF(I5<>"",I5*J10,"") was working for me, but I changed I5, so it now reads 0 instead of being blank. How do I get rid of that error and make it be blank now that I have a 0 in I5? Thank you in advance.

Reply With Quote