Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Set up a rate table like 0.01 20% 100 19% 500 18% .... 10,000 2% suppose this is in the range M1:N20 then use a lookup function =VLOOKUP(A2,$M$1:$N$20,2,TRUE)*A2 Where A2 contains the cost of an item. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Anna" wrote: I am a small business owner and what I need is to price my inventory. Let's say my lowest cost ($0.01) will be multiplied by 20%....and my highest cost ( $10.000) will be multiplied by 2%? Is there a formula to do it and if yes,,,what it is? Somebody suggested I should use the Conditional Formatting/Formula. Is it the best for my need and if yes, how do I do it? Can you give me more details? Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I paste without EXCEL increasing the cell number ? | Excel Worksheet Functions | |||
Increasing Number | Excel Discussion (Misc queries) | |||
Increasing number of columns beyond IV | Excel Worksheet Functions | |||
microsoft excel does not calculate - Automatic calculation is enab | Excel Discussion (Misc queries) | |||
calculate interest on an increasing balance with variable rate | Excel Discussion (Misc queries) |