vidyashankara
New Member
- Joined
- Mar 24, 2014
- Messages
- 16
Hi All, I need your help with a problem. Lets say I have a spreadsheet like below. I want to determine the value at which X value, A1, A2, A3, ..., etc.. crosses 0.5? Is there a formula to do this easily? For e.g., A1 reaches 0.5 at 43.4. A2 and the rest reach 0.5 at higher X values not shown here... Is there a formula to reach X and A1 and print the X value where A1 reaches 0.5 (or other specific value)?
<colgroup><col width="56" span="6" style="width: 42pt; text-align: center;"> </colgroup><tbody>
</tbody>
X | A1 | A2 | A3 | A4 | A5 |
40 | 0.35 | 0.20 | 0.10 | 0.02 | 0.22 |
40.2 | 0.36 | 0.21 | 0.10 | 0.02 | 0.23 |
40.4 | 0.37 | 0.21 | 0.11 | 0.03 | 0.24 |
40.6 | 0.38 | 0.22 | 0.11 | 0.03 | 0.25 |
40.8 | 0.39 | 0.23 | 0.12 | 0.03 | 0.26 |
41 | 0.40 | 0.24 | 0.12 | 0.03 | 0.26 |
41.2 | 0.40 | 0.25 | 0.12 | 0.03 | 0.27 |
41.4 | 0.41 | 0.25 | 0.13 | 0.03 | 0.28 |
41.6 | 0.42 | 0.26 | 0.13 | 0.03 | 0.29 |
41.8 | 0.43 | 0.27 | 0.14 | 0.04 | 0.30 |
42 | 0.44 | 0.28 | 0.14 | 0.04 | 0.31 |
42.2 | 0.45 | 0.29 | 0.15 | 0.04 | 0.32 |
42.4 | 0.46 | 0.30 | 0.15 | 0.04 | 0.33 |
42.6 | 0.47 | 0.31 | 0.16 | 0.04 | 0.35 |
42.8 | 0.47 | 0.32 | 0.16 | 0.05 | 0.36 |
43 | 0.48 | 0.33 | 0.17 | 0.05 | 0.37 |
43.2 | 0.49 | 0.34 | 0.17 | 0.05 | 0.38 |
43.4 | 0.50 | 0.35 | 0.18 | 0.05 | 0.39 |
43.6 | 0.51 | 0.36 | 0.19 | 0.06 | 0.40 |
43.8 | 0.52 | 0.37 | 0.19 | 0.06 | 0.41 |
44 | 0.53 | 0.38 | 0.20 | 0.06 | 0.42 |
44.2 | 0.54 | 0.39 | 0.21 | 0.06 | 0.43 |
44.4 | 0.55 | 0.40 | 0.21 | 0.07 | 0.44 |
44.6 | 0.56 | 0.41 | 0.22 | 0.07 | 0.46 |
44.8 | 0.57 | 0.42 | 0.23 | 0.07 | 0.47 |
45 | 0.58 | 0.43 | 0.24 | 0.08 | 0.48 |
<colgroup><col width="56" span="6" style="width: 42pt; text-align: center;"> </colgroup><tbody>
</tbody>