View Single Post
 
Old 04-25-2017, 08:07 AM
John 1978 John 1978 is offline Windows 10 Office 2016
Novice
 
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