Find Jobs
Hire Freelancers

Google Sheets Formula

$5-10 USD

已完成
已发布将近 6 年前

$5-10 USD

货到付款
We are trying to make a dynamic calculation on our "Bid Sheet". The Bid Sheet should be where the calculations final output will be. The "Products/Services" and "Rates" sheets are for reference for the calculations. We want the drop down menu “Item" and “Model" on the Bid Sheet to select the appropriate item on the “Products/Services" sheet and “Rates” sheet and fill in the price each and labor hours for the appropriate drop down item. In the examples given (A4 through F4) we were only able to hard code the calculations. We need them to be dynamic so that when any combination of “item” and “model” is selected the correct price and labor hours from the Products/Services and Rates sheets show for the selections. We plan to manage the labor hours on the Rates sheet so if we need to change the labor rate calculation, we want to do so by only changing the value on the “Rates” sheet. We plan to manage the Products/Services costs on the "Products/Services” sheet, we want to do so by only changing the value on the "Products/Services” sheet. If you do not understand my explanation, please let me know, I would be happy to clarify.
项目 ID: 17008213

关于此项目

5提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
I graduated from Penn State's honors college with a degree in finance. I have worked in both asset management and investment banking. My Excel skills are extensive. I know how to use all functions and tools and know basic VBA coding. I think I would be the ideal candidate for this project. I could accomplish it in just a few minutes.
$12 USD 在0天之内
5.0 (4条评论)
3.6
3.6
5威客以平均价$19 USD来参与此工作竞价
用户头像
A proposal has not yet been provided
$25 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
My Dear I'm read you job description carefully, you problems: 1- you drop down list should be depend on to gather item and models. 2- when you select item and model not get all values in price and labor hours correctly. 3- when you copy the total price is not calculation correctly. Mu solution are: 1- correct the drop down list to be select item and model no return right value in price and labor hours. 2- solve the problem when copy the total price for each one in the column. With My Regards.
$20 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
$25 USD 在1天之内
5.0 (1条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Durand, United States
5.0
7
付款方式已验证
会员自6月 4, 2015起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。