LinkBack URL
About LinkBacks
Hi,
In cell K5, try this formula:
Cheers,
=LOOKUP(C5,{0,89,96.17,97.18,99},{0,50,100,150,200})
Hi,
In cell K5, try this formula:
Cheers,=LOOKUP(C5,{0,89,96.17,97.18,99},{0,50,100,150,200})
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
create a lookup value in any other cell with the following figures
89.00 $ 0.00
96.16 $ 50.00
97.17 $100.00
98.99 $150.00
1000000 $200.00
Then type the following formula in K5 =VLOOKUP(C5,LookupRange,2, TRUE)
please change your LookupRange with the cell you are setting your lookup table
hope it helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks