Difficult Question -

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not even sure where to begin. How can I make certain calculations happen
by choosing an item in a list? For example - Let's say buys 2 annuities and
Bill's life expectancy is 35 years:

BenefitType Cost
Guaranteed Expected
(1) $1,000/mo 10 year/Period Certain 100,000 120,000
120,000

(2) $700/mo for Life/20 years certain 100,000 168,000
294,000

TOTAL 200,000
288,000 414,000


So when I choose (2) I want the "Expected" calculation to use
[LifeExpectancy] like: $700 x 12 x [35] = 294,000. HOWEVER, When choosing (1)
I don't want to use Life expectancy to calculate "Expected". Can anyone make
sense out of this?

Thanks,

John
 
Thanks Patrick. I'm not sure what to do with this - where do I put this and
am not sure what x=1 and epr1 mean - I was performing these calcualtions in
the form but are you suggesting I use a query?

Thanks,

John

Patrick Stubbin said:
use iif(x=1, expr1, expr2)
--
Regards


Patrick Stubbin


jmuirman said:
I'm not even sure where to begin. How can I make certain calculations happen
by choosing an item in a list? For example - Let's say buys 2 annuities and
Bill's life expectancy is 35 years:

BenefitType Cost
Guaranteed Expected
(1) $1,000/mo 10 year/Period Certain 100,000 120,000
120,000

(2) $700/mo for Life/20 years certain 100,000 168,000
294,000

TOTAL 200,000
288,000 414,000


So when I choose (2) I want the "Expected" calculation to use
[LifeExpectancy] like: $700 x 12 x [35] = 294,000. HOWEVER, When choosing (1)
I don't want to use Life expectancy to calculate "Expected". Can anyone make
sense out of this?

Thanks,

John
Click to expand...
Click to expand...
 
Back
Top