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
Bookmarks