[Solved] IFERROR conversion from Excel

Discuss the spreadsheet application

[Solved] IFERROR conversion from Excel

Postby grahamxy » Tue Jan 27, 2015 8:56 am

I hope someone can fix this relatively simple question, I am converting an Excel spreadsheet that has the formula ......iferror(AVERAGE(B20:H20));"" and trying to add iserror to make it work in OpenOffice but it won't calculate I just get a 0% in the cell. My formula is as follows IF(ISERROR(AVERAGE(B20:H20));"") What am I doing wrong?

TIA
Last edited by Hagar Delest on Tue Jan 27, 2015 10:34 pm, edited 1 time in total.
Reason: tagged [Solved].
OS X Yosemite Version 10.10.1 OpenOffice Version 4.1.1
grahamxy
 
Posts: 41
Joined: Sat Dec 20, 2014 6:03 am

Re: IFERROR conversion from Excel

Postby RusselB » Tue Jan 27, 2015 9:30 am

You still need to specify what should be displayed if the average does not contain an error.
I suspect you probably want the average, so try
Code: Select all   Expand viewCollapse view
=if(iserror(average(b20:h20));"";average(b20:h20))
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5193
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: IFERROR conversion from Excel

Postby karolus » Tue Jan 27, 2015 9:56 am

Maybe simplified with:

Code: Select all   Expand viewCollapse view
=IF(COUNT(B20:H20);AVERAGE(B20:H20);""


Karolus
AOO4, Libreoffice - 5.1 … 5.3.2.2 on Linux Mint17
User avatar
karolus
Volunteer
 
Posts: 851
Joined: Sat Jul 02, 2011 9:47 am

Re: IFERROR conversion from Excel

Postby Zizi64 » Tue Jan 27, 2015 10:14 am

There is "IFERROR"() function in LibreOffice Calc.
Last edited by Zizi64 on Tue Jan 27, 2015 10:37 am, edited 1 time in total.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8093
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: IFERROR conversion from Excel

Postby grahamxy » Tue Jan 27, 2015 10:28 am

[SOLVED] Thanks guys, all working just perfect. Is there any reason OpenOffice doesn't have the same conditions as LibreOffice seeing that they are so similar. As I have come across a few instances where various formulae and conditions don't work here but do in Libre. I will always use OO but sometimes I struggle.
OS X Yosemite Version 10.10.1 OpenOffice Version 4.1.1
grahamxy
 
Posts: 41
Joined: Sat Dec 20, 2014 6:03 am

Re: IFERROR conversion from Excel

Postby RusselB » Tue Jan 27, 2015 11:46 am

I think, but am not positive, that it has something to do with the different types of licences.. then again, it may be that someone just hasn't taken the time to code IFERROR (along with a lot of other things people ask for) for OpemOffice.
If you are struggling to complete something in OO,, then don't hesitate to ask... I can't guarantee that we'll have a fast or easy response, but it's rare for a question to get no response.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5193
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: No registered users and 25 guests