Conditional operation
 

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
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

--
HTH

Bob Phillips

"Shetty" wrote in message
oups.com...
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
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.