If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|