Inserting arrays as variables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anthonyd - 25 Jul 2007 21:24 GMT

How can I insert an array or range of variables (e.g. .042 to .168) into a
formula? Alternatively, can I define variables (e.g. x, y) without having to
use Visual Basic?

I'm trying to create a chart which outputs values based on constants and a
function involving the range of variables.

Thanks for your help!

Reply to this Message

Bob Phillips - 26 Jul 2007 00:00 GMT

{0.042,0.07,0.1,0.11,0.123,0.13,0.168}

as an example

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> How can I insert an array or range of variables (e.g. .042 to .168) into a
> formula? Alternatively, can I define variables (e.g. x, y) without having
[quoted text clipped - 5 lines]
>
> Thanks for your help!

Reply to this Message