It looks to me like it should be a simple lookup function. The VLOOKUP() function is probably easiest to understand: http://office.microsoft.com/en-us/ex...011.aspx?CTT=1 One particular note: study how it uses the 4th range_lookup argument to handle the "in between" parts of your desired results.
Because J is to the left of K, VLOOKUP won't actually work for your setup, though it should work just fine if you switch them. Assuming you switch J and K (and use only the lower boundary for each division), then the formula would look something like: =C4*vlookup(c4,$J$4:$K$8,2) the table might look something like:
LinkBack URL
About LinkBacks
Multiple formulas in one cell but all related
Register To Reply
Originally Posted by shg
Bookmarks