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.