Try this:

=B2/A2*1500
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Farhad" wrote in message
...
Hey,

i have some data as follow:

Quantity Price
250 4391.95
500 3802.00
750 3598.55
1000 3415.00

i want to know if there is a functioni n excel that caculate the price for
example in 1500 quantity?

any help would be appreciated.

Thanks,
--
Farhad Hodjat