IFERROR not (consistently) working

Talk about anything at all....

IFERROR not (consistently) working

Postby Dodulation » Tue Apr 25, 2017 3:47 pm

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 works fine after the 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),"")
Office 2016
Dodulation
 
Posts: 4
Joined: Tue Apr 25, 2017 3:35 pm

Re: IFERROR not (consistently) working

Postby RoryOF » Tue Apr 25, 2017 4:03 pm

Check your data type using /View /Value highlighting.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29092
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: IFERROR not (consistently) working

Postby Dodulation » Tue Apr 25, 2017 4:39 pm

Where can I find that?
Office 2016
Dodulation
 
Posts: 4
Joined: Tue Apr 25, 2017 3:35 pm

Re: IFERROR not (consistently) working

Postby RoryOF » Tue Apr 25, 2017 4:47 pm

Are you sure you are using OpenOffice Calc? What does /Help /About tell you you are using?
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29092
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: IFERROR not (consistently) working

Postby Dodulation » Tue Apr 25, 2017 4:49 pm

No excel
Office 2016
Dodulation
 
Posts: 4
Joined: Tue Apr 25, 2017 3:35 pm

Re: IFERROR not (consistently) working

Postby RoryOF » Tue Apr 25, 2017 4:54 pm

Then you are wasting your time here - this Forum is for OpenOffice and derivatives. Excel is a Microsoft commercial product.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29092
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: IFERROR not (consistently) working

Postby Dodulation » Tue Apr 25, 2017 4:58 pm

My bad, I thought it was a forum about all programs. Thanks anyway.
Office 2016
Dodulation
 
Posts: 4
Joined: Tue Apr 25, 2017 3:35 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 2 guests