Question description:
This user has given permission to use the problem statement for this
blog.
I need a column to total (Hours)(85) + (Travel)(.55) per line
Solved by F. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/09/2018 - 01:56
Welcome to ExcelChat!
User
29/09/2018 - 01:57
Hi :)
Excelchat Expert
29/09/2018 - 01:57
I see that your question is about total of hours and travel. I will help you with the problem and explain the solution afterwards.
Excelchat Expert
29/09/2018 - 01:57
Before we get started, this is a reminder that our policy is one problem per session with additional Q&A on that problem as time allows.
Excelchat Expert
29/09/2018 - 01:57
Let me ask you a couple of quick questions to make sure I fully understand your problem.
User
29/09/2018 - 01:57
Ok, thank you so much
Excelchat Expert
29/09/2018 - 01:57
Would you like to share the file where you need to have the solution?
User
29/09/2018 - 01:57
no, its on another computer
Excelchat Expert
29/09/2018 - 01:58
Okay, could you please make a small data example of your task on the sheet near the chat?
User
29/09/2018 - 01:58
but if you need, i can recreate it on this one...its simple.
Excelchat Expert
29/09/2018 - 01:59
Okay, so the result should be in column C
User
29/09/2018 - 01:59
yes,
Excelchat Expert
29/09/2018 - 01:59
Do you want to have a sum of 80% of hours and 55% of travel?
User
29/09/2018 - 01:59
but i need the hours to be muliplied by 85 and the travel to be multiplied by .55 andTHAT total need to be in the 3rd column
User
29/09/2018 - 02:00
no, 85 and .55 are rates
Excelchat Expert
29/09/2018 - 02:00
Okay, great, I got your task
Excelchat Expert
29/09/2018 - 02:00
Will do it in a minute and explain that to you
User
29/09/2018 - 02:00
thank you so much
Excelchat Expert
29/09/2018 - 02:00
Your result is ready at C2
Excelchat Expert
29/09/2018 - 02:00
The formula which we used is:
Excelchat Expert
29/09/2018 - 02:00
=A2*85+B2*0.55
Excelchat Expert
29/09/2018 - 02:01
So just a straight solution for the problem
Excelchat Expert
29/09/2018 - 02:01
Is this the result which you were looking for?
User
29/09/2018 - 02:01
YES!
Excelchat Expert
29/09/2018 - 02:01
Great! Do you have any questions left?
User
29/09/2018 - 02:01
you are awesome! been trying to figure that out for hours lol
Excelchat Expert
29/09/2018 - 02:02
ExcelChat can help to save a lot of time
User
29/09/2018 - 02:02
I always think excel you have to have some weird formula
Excelchat Expert
29/09/2018 - 02:02
In most cases yes, but it also supports basic operators
User
29/09/2018 - 02:02
let me plug it in and see if it works on my end.
Excelchat Expert
29/09/2018 - 02:02
Sure, please check it
User
29/09/2018 - 02:03
Its not working
Excelchat Expert
29/09/2018 - 02:04
Could you share a screenshot or file where you have this problem?
User
29/09/2018 - 02:04
im getting 23,854.60 in the first cell and all the other ones have #VALUE
User
29/09/2018 - 02:04
sure, give me a sec
User
29/09/2018 - 02:06
[Uploaded an Excel file]
User
29/09/2018 - 02:06
...can you see it? lol
Excelchat Expert
29/09/2018 - 02:07
Yes, can you also show the formula in G10?
User
29/09/2018 - 02:07
no
Excelchat Expert
29/09/2018 - 02:07
Once you entered the formula in G9, you can copy it down and it will work fine for the rest of the cells
User
29/09/2018 - 02:08
and the total is wrong
User
29/09/2018 - 02:08
..i wish it was right lol...
Excelchat Expert
29/09/2018 - 02:08
Oh, actually the problem is that you didn't change the columns Letter
Excelchat Expert
29/09/2018 - 02:08
Please change it to the following formula:
Excelchat Expert
29/09/2018 - 02:09
=E9*85+F9*0.55
Excelchat Expert
29/09/2018 - 02:09
Because A2 and B2 were the cells that we used in our example
User
29/09/2018 - 02:09
OH lmao
User
29/09/2018 - 02:09
sorry
User
29/09/2018 - 02:09
duh
Excelchat Expert
29/09/2018 - 02:09
So in your actual file you have to reference the real cells of hours and travel
Excelchat Expert
29/09/2018 - 02:09
No problems, Excel may confuse at first
Excelchat Expert
29/09/2018 - 02:10
But if you started the way of automation, I think in future you will love it
User
29/09/2018 - 02:10
no, its early for me and baby kept me up....im not firing on all pistons today
User
29/09/2018 - 02:10
it works!!!!
Excelchat Expert
29/09/2018 - 02:10
Great to hear that!
User
29/09/2018 - 02:10
UGH I COULD HUG YOU LOL
Excelchat Expert
29/09/2018 - 02:10
Hahaha:) Thank you!
Excelchat Expert
29/09/2018 - 02:11
Are there any questions left about the problem or solution?
User
29/09/2018 - 02:11
no, that covers it
User
29/09/2018 - 02:12
I am defiantly going to look into investing into this program!
User
29/09/2018 - 02:12
I cant thank you enough
Excelchat Expert
29/09/2018 - 02:12
You are welcome! Thanks for coming us
Excelchat Expert
29/09/2018 - 02:12
If it happens that you have any Excel or Google Sheets problems in future, please don't hesitate to reach us again.
Excelchat Expert
29/09/2018 - 02:12
You may now end the session and leave any comments or feedback - I do appreciate the feedback left. Have a nice day!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
