IF statments

		Microsoft Office Forums > Microsoft Excel > Excel
IF statments

FAQ

Thread Tools

Display Modes

07-19-2017, 08:37 AM

Tye Rogers Tye Rogers is offline

Windows 10 IF statments

Office 2016

Novice

Join Date: Jul 2017

Posts: 1

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
need help with If statments or VB if possible	jerryj	Excel Programming	1	05-04-2012 08:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:08 PM.