Microsoft Office Forums

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

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,100
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 »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


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 11:41 AM.

Contact Us - Privacy Statement - Top

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