There you go you can use this if formula...which will do what you want...

lets say you have value in a1 then...

=if(a1=<2000000,a1*.5,if(and(a1>2000000,a1=<2500000),a1*.6,a1*65))

Saurabh...

lets say you have value in a1 then...

=if(a1=<2000000,a1*.5,if(a

Saurabh...