Excel formula

Need a formula

If quantity is 1000 and rate is 260 then amount is 260 because the rate is per 1000.
Please note the rate is per 1000, if i put 2000 in quantity and 260 in rate it should automatically double in amount coloumn.
If i put 3000 in quantity and 260 in rate it should automatically come 3 times of 260 in amount coloumn.

Nick's picture

  q r amnt FORMULA in

 


q r amnt FORMULA in col C
1000 260 260 =B2*A2/1000
2000 260 520 =B3*A3/1000
3000 260 780 =B4*A4/1000
       
       

Excel formula

Thanks alot its working...