IF statments

		Microsoft Office Forums > Microsoft Excel > Excel
IF statments

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 12:46 PM.