Function Question
 

I have a spreadsheet that is calculating total cost based on the region of
the country and total weight of a project that the user selects.

The whole story is that a user selects a region of the USA from a drop down
box. Then the user enters in the estimated total weight (lbs) for the
project.

The function I am looking for looks for the region, then when selected, it
looks at a set of values for that region, doing a couple calculations based
on 5 cells information, then producing a result. The weight entered is
involved in the calculation.

Email me any questions or solutions to

Function Question
 

Looks like you want to use a VLOOKUP function. As you didn't provide any
other details as to what you want done, I'm afraid I can't offer any other
help.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"steinerdf" wrote:

I have a spreadsheet that is calculating total cost based on the region of
the country and total weight of a project that the user selects.

The whole story is that a user selects a region of the USA from a drop down
box. Then the user enters in the estimated total weight (lbs) for the
project.

The function I am looking for looks for the region, then when selected, it
looks at a set of values for that region, doing a couple calculations based
on 5 cells information, then producing a result. The weight entered is
involved in the calculation.

Email me any questions or solutions to

Function Question
 

Hi,

Please show us what your data looks like and a sample of the desired result
based on that sample data.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"steinerdf" wrote:

I have a spreadsheet that is calculating total cost based on the region of
the country and total weight of a project that the user selects.

The whole story is that a user selects a region of the USA from a drop down
box. Then the user enters in the estimated total weight (lbs) for the
project.

The function I am looking for looks for the region, then when selected, it
looks at a set of values for that region, doing a couple calculations based
on 5 cells information, then producing a result. The weight entered is
involved in the calculation.

Email me any questions or solutions to

Function Question
 

See below.

Region: Northwest
Est weight for the project: 100,000


Northwest region

$5.1
$4.0
$5.2
$5.3
$5.4


A user would select the region and enter in a weight. Once the weight is
entered the calculation would start. See below for the calculation.

=
($5.1*100,000/100)+(($4.0*(100,000*.50)/100)*2)+($5.2*2500/100*(100,000*.05/2500))+($5.3*14000/100*(100,000*.95/14000)+($5.4*100,000/100)


Hope this helps.


"Shane Devenshire" wrote:

Hi,

Please show us what your data looks like and a sample of the desired result
based on that sample data.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"steinerdf" wrote:

I have a spreadsheet that is calculating total cost based on the region of
the country and total weight of a project that the user selects.

The whole story is that a user selects a region of the USA from a drop down
box. Then the user enters in the estimated total weight (lbs) for the
project.

The function I am looking for looks for the region, then when selected, it
looks at a set of values for that region, doing a couple calculations based
on 5 cells information, then producing a result. The weight entered is
involved in the calculation.

Email me any questions or solutions to