Results 1 to 4 of 4

Table index challenge

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-31-2006
    Location
    Oslo, Norway
    MS-Off Ver
    MS 365 Business
    Posts
    287

    Table index challenge

    Please see the enclosed file.
    I have a table and two reference cells: C22 and C23.
    In this case the reference cells read 500/200000 which returns 160, which is the result I want.

    The challenge is that the values in the reference cells could be any number, and these number have to be rounded up to the numbers in the tabel.

    Could anyone help me with the formula? (INDEX/OFFSET....?)

    Saturn
    Attached Files Attached Files

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