![]() |
#2
|
|||
|
|||
![]()
With KG in B2 maybe this one:
=LOOKUP(B2,{0,45,100,300,500,1000}+0.01,{100,110,2 00,220,300,330}) Last edited by xor; 09-07-2017 at 02:16 AM. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
![]() |
jomwelsh | Excel | 6 | 04-07-2016 08:20 AM |
Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
help with a look up or if formula | beb1227 | Excel | 3 | 12-31-2011 01:08 PM |
![]() |
OneOleGuy | Excel | 4 | 03-05-2011 09:54 AM |