## [Solved] IFERROR conversion from Excel

### [Solved] IFERROR conversion from Excel

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

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.7 and LibreOffice 6.3.3.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.

RusselB
Moderator

Posts: 5853
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

### Re: IFERROR conversion from Excel

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

karolus
Volunteer

Posts: 852
Joined: Sat Jul 02, 2011 9:47 am

### Re: IFERROR conversion from Excel

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, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.0; AOO4.1.6
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.

Zizi64
Volunteer

Posts: 8771
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

### Re: IFERROR conversion from Excel

[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

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.7 and LibreOffice 6.3.3.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.

RusselB
Moderator

Posts: 5853
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON