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