Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page IF statments
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 07-19-2017, 08:37 AM
Tye Rogers Tye Rogers is offline IF statments Windows 10 IF statments Office 2016
Novice
IF statments 		 
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
  #2  
Old 07-19-2017, 08:43 AM
xor xor is offline IF statments Windows 10 IF statments Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
If((i5<>0)*(i5<>""),i5*j10,"")
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF statments 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 06:35 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft