Converting Excel formula to Microsoft Works spreadsheet

[Bob in Portage]

I have an excel spreadsheet that I want to provide to someone who only has Microsoft Works spreadsheet available. Everything converts okay except the following formula:

=if(count(g8:g27)>=10,average(small(g8:g27,{1,2,3,4,5,6,7,8,9,10})))*0.96

Can someone give the equivalent Works spreadsheet formula?

Thanks.

Bob in Portage

 

[RalphA]

You cite that your Excel formula is:

=if(count(g8:g27)>=10,average(small(g8:g27,{1,2,3,4,5,6,7,8,9,10})))*0.96

I think you need a comma and a value, say zero, between the last and the second-to-last parenthesis, so: ...8,9,10})),0)*0.96

In Works:
The "count" function is O.K. and the "average" function is AVG. But, there is no equivalent "small" function.

So, the basic, unsolved problem seems to be the creation of a method to obtain the 10 smallest values in the given range. Hopefully, some more knowledgeable person will post this method.

 

[RalphA]

Oops, posted the same reply twice. I have now deleted it. Sorry.