![]() |
#1
|
|||
|
|||
![]()
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),"") |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Gary91 | Word | 3 | 01-21-2015 05:52 AM |
Visio 2010: Polygons not closing consistently | Orthoducks | Visio | 0 | 07-14-2014 04:52 PM |
![]() |
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 |