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?

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 )

Google photo

You are commenting using your Google 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.