A simple formula for spreadsheet

Hello,

not easy, huh Raymond :)

I'm trying something else lol
in H2 you put =C2-(E2*F2) invoice amount - the number of tickets multiplied by 5 euros

Have a good day
--
Every problem has a solution... you just need to be persistent.

Good evening
I see it this way: restaurant cost - sum of the tickets, the remainder divided by the number of guests
now we need to determine
1) number of guests who participated in the form of tickets

2) if the ticket value is the same for everyone
this can be done with a proportion calculation, the main thing is to have all the parameters in order to always have 100%

Hello Raymond
I realize that we are moving from subtraction to calculating proportions with variable data; indeed, the only fixed value is the expense; now to be able to put this into a spreadsheet, it is vital to know the range of "employer participation" because this is essential to determine the amount actually spent by each guest
Given that: if the ticket value is "standard": it's not difficult, but if the ticket value is variable (tickets at 7, 8, 10 $ and employer contributions are different), we need to build a spreadsheet with multiple entries that ("puts into equation") all possible scenarios (not quite headache-inducing, but almost)
Here is an interesting topic; basically, it "suffices" to figure out each person's share based on their contribution
It's raining here, we would need "tropical vibes"
Have a good day

Hello
Well, maybe not, I had tinkered with something similar; the hardest part is knowing the basic values; it is always possible to make a mock-up with fake values
1/4 of Lexomil should be enough.

re
here is the factory; with the spinner we display the total then we click on the choices; it returns the share of each selected element relative to the whole
http://www.cijoint.fr/cjlink.php?file=cj201002/cij77Mk7pY.xls
it's DIY

Hello,

here is your file as I understand it
http://www.cijoint.fr/cjlink.php?file=cj201002/cijiiWmLB8.xlsx

And by the way, I am really a good sport. Since the beginning of your message, you've been making us work for nothing, either because you're only giving a few details, or because all of a sudden (Post 18) you decide to tell us that you are sharing the bill. You know, as Raymond mentioned to you so well, you know what you're talking about and you know what you want to do... not us.

Thank you

Good night
--
Every problem has a solution... you just have to be persistent.