[Solved] IFERROR conversion from Excel

[grahamxy]

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

[RusselB]

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

=if(iserror(average(b20:h20));"";average(b20:h20))

[karolus]

Maybe simplified with:

Code: Select all

=IF(COUNT(B20:H20);AVERAGE(B20:H20);"") 

Karolus

[Zizi64]

There is "IFERROR"() function in LibreOffice Calc.

[grahamxy]

[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.

[RusselB]

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.