Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-25-2017, 08:07 AM
John 1978 John 1978 is offline IFERROR not (consistently) working Windows 10 IFERROR not (consistently) working Office 2016
Novice
IFERROR not (consistently) working
 
Join Date: Apr 2017
Posts: 3
John 1978 is on a distinguished road
Default IFERROR not (consistently) working

I have a fairly simple equation with an IFERROR function to calculate some currency ---> =IFERROR(K67+(K67*L67),"")



If there is no input I want it to show nothing ("") and if there is input it shows the amount in dollars. That function works fine and comes back quite a bit in this sheet. Nevertheless, it stops working fine after line 66 so line 67 - which is just a copied version of the 66 one - does not show a blank (empty) cell but $0.00. Does anyone have an idea how this is possible? All functions are exactly the same.

Working function ---------> =IFERROR(K60+(K60*L60),"")
Not working function ----> =IFERROR(K67+(K67*L67),"")
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
IFERROR not (consistently) working TOC Not Working Gary91 Word 3 01-21-2015 05:52 AM
Visio 2010: Polygons not closing consistently Orthoducks Visio 0 07-14-2014 04:52 PM
IFERROR not (consistently) working working 4 10's, need help to set up rkirkland Project 1 12-19-2012 02:47 PM
Autocomplete not working? waltdisneypixar Excel 3 07-30-2012 09:44 AM
Is it possible for Excel print consistently with any printer? avoid awkward page brea William C Excel 1 12-21-2010 01:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:33 AM.


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