<< > Question on the omnigo formula capabilities.
>
> I need a formula like this.
> --------------------------------------------------
> Q = B * 16.6666666666
> E = B * 8.33333333333
> S = B * 4.16666666666
> -------------------------------------------------
> I want to be able to enter the value of > B < and then get the answers for
> Q E and S. How can I write this formula on the omnigo finance program?
>>
Sounds like a job for Spreadsheet.
---------------------
Forwarded message:
From: mlv@pobox.com (Michael L. Vezie)
Sender: owner-ogo@lifelike.com
To: 102115.2437@CompuServe.com
CC: ogo@lifelike.com
Date: 96-12-13 10:56:54 EST
In a previous message, Chris Erlanson <102115.2437@CompuServe.COM> wrote:
> Question on the omnigo formula capabilities.
>
> I need a formula like this.
> --------------------------------------------------
> Q = B * 16.6666666666
> E = B * 8.33333333333
> S = B * 4.16666666666
> -------------------------------------------------
> I want to be able to enter the value of > B < and then get the answers for
> Q E and S. How can I write this formula on the omnigo finance program?
The problem is that you can't have one formula with 3 unknowns.
So while you could, in theory, set up one formula with an 'IF'
that includes all three formulas (although that proves impossible
to solve), you would still have to know B, Q, E, before solving for
S.
With that in mind, you have two choices:
Enter three separate formulas in the same case, one for Q, one for E,
and one for S. Then go into each, and given a B, get the answer you
want.
But the easier option is to just do it in a spreadsheet. That would
make it trivial.
For example:
A B
1 ["B"] [whatever]
2 ["Q"] [=B1 * 16.6666666]
3 ["E"] [=B1 * 8.33333333]
4 ["S"] [=B1 * 4.16666666]
(I may recommend, in the interest of accuracy, you change the constants
to 50/3, 25/3, and 12.5/3 respectively)
Then enter any value you want in B1, and you'll see the answer
immediately.
In Christ,
Michael