how to count discount price

Hi Friends,

I want a formula for calculation, Suppose a cellular company charges a customer for first 1min will be charged with 60p and 2nd min will be charged with 40p and remaning min will be charge with 20p what formula to be used so that whenever i enter certain min it will calculate according to above charges...

please help me with the formula.

Thanks & Regards
Vivek

Hi vive,

You can use the VLookup() function

Type the following text in column E and F (E1:F3)
E F
1 60
2 40
3 20

Now type the Lookup formula in B1 .....=VLOOKUP(A1,E1:F3,2,TRUE)

Enter

Then type a value in cell A1 and check Whether it is ok or not.

Visit http://excelsenior.com/

Thanks guys for you help but janagan i think you didn't get my question anyways thanks for replying &

PietBom Thanks you applied perfect formula can you tech me that formula coz i want to learn to apply it in various situations...

Thanks PietBom you tried to explain me but still I am not able to uderstand it, but anyways it is very nice formula
you have applied but please try to explain me in more easy way