Perhaps try formatting the result to more decimal places and/or use
scientific. It could be the correct result is already returned.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"texanfanrocket" wrote in message
...
That stopped the error message, but it didn't compute the answer. It came
back with 0%.
"Max" wrote:
Try, array-entered (press CTRL+SHIFT+ENTER)
something like:
=AVERAGE(IF(ISNUMBER(A1:A10),A1:A10))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
|