Specify specific cell in the formula

3 views (last 30 days)
I am working with mortality tables and my question is how can I specific a specific cell (e.g. the value of the variable discount_px when the age is 77)?
I have created this table containing four variables (Age, qx, px, discount_px)
Age qx px discount_px
75 0.038258 1 1
76 0.042116 0.96174 0.95602
77 0.046321 0.92124 0.91031
78 0.050916 0.87856 0.86298
79 0.055988 0.83383 0.81417
80 0.061493 0.78715 0.76402
If my formula is:
A = Age * (discount_px for age 77)
my outcome should be:
A = 77*0.91031
How can I specific in the formula that discount_px should take the value for age = 77?

Accepted Answer

madhan ravi
madhan ravi on 28 Sep 2020
ix = TaBle.Age == 77;
A = TaBle.Age{ix, :} * TaBle.discount_px{ix, :}

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!