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?