Excel formula help

Occasional Visitor

I have what is probably a simple school exam question to solve with Excel.  I have two groups of members of an Arts society.  There are 7 in each group.  All full members pay only 85% of any unit cost, divided by 7 in this case whereas the non-members have to pay the full 100% divided by 7.


There are two distinct unit costs, of £400 and £550, i.e., a total of £950.  The calculation outcome must not be in debit but if any excess occurs it will be shared and given back to all concerned


Thought I was good at Excel but this has stumped me and many more of the group too!


Could do with a solution PDQ please, before the arties  start a revolution.

Thanks, Jon

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies