Results 1 to 5 of 5

Values in an Index

Threaded View

nnabijan Values in an Index 03-06-2012, 05:06 PM
Domski Re: Pkease help 03-06-2012, 05:08 PM
Domski Re: Values in an Index 03-06-2012, 05:28 PM
nnabijan Re: Values in an Index 03-06-2012, 05:52 PM
nnabijan Re: Values in an Index 03-08-2012, 04:41 AM
  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    Riyadh
    MS-Off Ver
    Excel 2007
    Posts
    3

    Values in an Index

    Dear Everyone,

    I have the following table in excel:

    _________________H______________________
    A 0.30 0.35 0.40 0.45 0.50 0.55 0.60
    2 0.390 0.433 0.473 0.509 0.543 0.573 0.587
    3 0.274 0.309 0.342 0.374 0.406 0.437 0.466
    4 0.207 0.235 0.261 0.289 0.318 0.346 0.374
    4.5 0.183 0.208 0.232 0.258 0.285 0.311 0.339
    5 0.164 0.187 0.209 0.232 0.258 0.287 0.310
    6 0.135 0.154 0.172 0.192 0.214 0.236 0.261
    7 0.114 0.130 0.145 0.163 0.177 0.202 0.224
    8 0.098 0.112 0.126 0.140 0.154 0.175 0.195
    9 0.0859 0.0981 0.1106 0.1233 0.1357 0.1543 0.1723
    10 0.0763 0.0873 0.0986 0.1096 0.1207 0.1375 0.1540
    11 0.0687 0.0786 0.0887 0.0988 0.1088 0.1240 0.1385


    if for A = 4, and H is 0.36 how to find the corresponding value in the index (between 0.35 and 0.4)

    H = 0.4, and A is 5.7 how to find the corresponding value in the index (between 5 and 6)

    and also for combined A 5.3 and H 0.52

    regards
    Last edited by nnabijan; 03-06-2012 at 05:24 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1