Hi zbor, thaks for quick reply,

but this is not my requirement..I want if Cell A1 is equal to 11 than reply 36 (cuz from 1 to 10 days rate is 3 dollars and and than next days i.e. 11 to 20 rat is USD 6, and 20 to onward is USD 12..

so if Cell A1 is = 5 than reply is 5x3 = 15,
if cell A1 is = 12 than rely is (10x3)+(2x6)= 32
if cell A1 is = to more than 20 i.e 25 than result is (10x3=30) + (10x6=60) + (5x12=60) = 150

Sorry if could not make u well understand.

Thanks