# Excel - IF Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

## Click here to get your free Excelchat help session

Trusted by people who work at