Conditional operation

  • Thread starter Thread starter Shetty
  • Start date Start date
S

Shetty

I need to work out a solution based on the following.
Say
B1=10000
B2=5000
B3=50000
B4=80000
B5=225000
etc

The corrosponding cells in column C is to be calculated as per the
following conditions
From 0 to 50000 =0
Click to expand...
from 50000 to 60000 =0.1%
from 60000 to 150000 =0.2%
from 150000 to 300000 = 0.3%
above 300000 = 0.4%

So results of C1 to C3 will be 0(zero), C4=5000, C5=41500 etc.
What formula should I put in the Column C?

Regards,
Shetty.
 
Shetty,

Your ranges overlap a bit so my boundaries may not be quite what you want,
but try this in C1

=VLOOKUP(B1,{0,0;5001,0.001;6001,0.002;15001,0.003;30001,0.004},2)

abd c opy down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Proportional | cumulative sum of bonus 3
combination of numbers 1
Showig differences in Month to Month data from data in the same ta 8
Index, Match 1
Multi criteria Sum 2
Match and Lookup 1
Subtracting based on 2 conditions 3
Conditional Format a dynamic list in Excel 2007 1

Back
Top