Function Question

[steinerdf]

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 (e-mail address removed)

 

[Luke M]

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.

 

[Shane Devenshire]

Hi,

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

 

[steinerdf]

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.