ExcelBanter - Math functions in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Math functions in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/131293-math-functions-excel.html)

Farhad

Math functions in Excel

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

Toppers

Math functions in Excel

Look at TREND Function.

"Farhad" wrote:

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

RagDyeR

Math functions in Excel

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

All times are GMT +1. The time now is 03:48 AM.