Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula that will calculate 20% of an amount if there is only one name. if there are two names then it needs to calculate 20% between the two names. i.e. 10% each
Solved by V. A. in 14 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
13/09/2018 - 02:31
Greetings! Welcome to ExcelChat!
Excelchat Expert
13/09/2018 - 02:31
Looks like you need help on some formulas, is that right?
User
13/09/2018 - 02:31
yes
Excelchat Expert
13/09/2018 - 02:31
Sure, I can help you with that.
Excelchat Expert
13/09/2018 - 02:31
Before we start, a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert
13/09/2018 - 02:32
That being said, do you have your sheet that you can share?
Excelchat Expert
13/09/2018 - 02:32
Or shall we just create sample data?
User
13/09/2018 - 02:32
sample data please
Excelchat Expert
13/09/2018 - 02:32
Alright
Excelchat Expert
13/09/2018 - 02:33
Question, will the two names be in one cell?
User
13/09/2018 - 02:34
no
Excelchat Expert
13/09/2018 - 02:34
Okay.
Excelchat Expert
13/09/2018 - 02:35
Please see the sheets, is this a good example?
Excelchat Expert
13/09/2018 - 02:36
Hello, are you still there?
User
13/09/2018 - 02:36
so basically sam should get 20% of $200 but if there is sam and tom they should get 20% between them
Excelchat Expert
13/09/2018 - 02:36
Got it.
Excelchat Expert
13/09/2018 - 02:37
I'm going to build the formula for you, this should take me just a few minutes.
User
13/09/2018 - 02:37
ok thansk you
Excelchat Expert
13/09/2018 - 02:40
Okay, here you go.
Excelchat Expert
13/09/2018 - 02:41
The data you'll need is in columns A to C, and then the formulas are in columns E to F
Excelchat Expert
13/09/2018 - 02:41
Are you good with this?
User
13/09/2018 - 02:42
great thank you!!!
Excelchat Expert
13/09/2018 - 02:42
Perfect!
User
13/09/2018 - 02:42
thank you so much!!!!!!
Excelchat Expert
13/09/2018 - 02:43
No worries. Do you need me to explain the formula to you?
Excelchat Expert
13/09/2018 - 02:43
By the way, you can download this sheet for your reference.
User
13/09/2018 - 02:43
no i got it thank you!!!
User
13/09/2018 - 02:43
brilliant help thank you
Excelchat Expert
13/09/2018 - 02:43
Alright, great! I will now mark this as answered then.
User
13/09/2018 - 02:43
yes :)
Excelchat Expert
13/09/2018 - 02:43
Happy to have helped! You may end the session now.
Excelchat Expert
13/09/2018 - 02:43
Thanks for coming to Excelchat. Feel free to leave any comments or feedback. Have a nice day.
Excelchat Expert
13/09/2018 - 02:44
Whenever you're ready, you may click the red button to end the session.
Excelchat Expert
13/09/2018 - 02:44
Cheers!
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.