"Dana DeLouis" wrote in message
...
Hi Sandy. This isn't to useful here, but you might be interested in
another
option.
I can never do this from inspection of the data. If you treat the data
table as a Signal pulse, and take the Inverse Fourier Transform, you
arrive
at the following suggestion:

=(1/2)*(3*SIGN(A1-999.999)+2*SIGN(A1-499.999)+3*SIGN(A1-249.999)+22)


Oh! come on Dana I'm a simple bicycle repair man - although it is true that
at school I was compared to Einstein - the teacher said to my parents, "Well
he's no Einstein!"

Re-arranging your truly excellent formula gives:

=SIGN(A1-499.999)+1.5*(SIGN(A1-249.999)+SIGN(A1-999.999))+11

which still seems to work, at least like your original, for whole numbers.

Regards

Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk