Graham Smith wrote:
Brian,
I've just copied the formula above from your message and pasted it into a
spreadsheet (stripping the braces and then using Ctrl+Shift+Enter) and
applied it to your values. It does work: at least, it gives me 0.304762 -
as you hope (version 3.0 for Windows XP). I cannot know what you are doing
wrong.
Nope, neither can I, because I am also getting 0.03 as an answer
rather than 0.3, as well as 0.2857. So as you suggest I must be doing
something wrong.
Thanks again.
Graham
Graham:
Any chance that your 8 in D2 is actually entered as 7.999. If I plug
this into the cell D2, the array formula will give a result of 0.2857
(rounded to 4 decimal places).
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
