How much do I need to pay?

This is not an Excel question…


Just had a happy dinner gathering with friends! Good food, good friend, and good price… 🙂

While a friend was calculating how much to share by each of us, others asked me how to use vlookup for that calculation.  Hahaha, I know that they were kidding!

I said: “We don’t need a vlookup for that (we don’t even need a spreadsheet to do that).  We just need to divide the total amount by the no. of people, right?”

She replied: ummmmm….. I want C to pay half of what the rest of the group pay, that needs a bit calculation…

then she came up with the amount. (I still think that she pays more for us… ;p)

Anyway, we still don’t need a spreadsheet to do that calculation.  As the requirement is one of us pays only half of the rest do, we can do it by the following equation:

C = T / (N x 2 -1) where T is the Total Amount; N is the number of people; C is the amount to be paid by the C

Then how much the rest of the group pay??  Should it be C x 2??? 

Does it make sense?


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in General. Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.