Math functions in Excel

[Guest]

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,

 

[Guest]

Look at TREND Function.

 

[RagDyeR]

Try this:

=B2/A2*1500
--

HTH,

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

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,