Results 1 to 5 of 5

Thread: Excel - Ensuring the difference is £5?

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2011
    Posts
    6

    Excel - Ensuring the difference is £5?

    I think this in theory is a really simple one but its driving me mad ! lol.

    Basically - looking at how you'd divide rents based on the cost/amount of people. Essentially, someone has said they will take the smallest room - if they pay £5 less a month, and the amount of people in the house is either going to be 3 or 4 - if its 4, the 2 in the smallest rooms should pay £5 less than those in the 2 bigger rooms (who pay the same).

    Sounds really simple, but I can't get it to work reliably. So essentially.... dividing a total cost by either 3 or 4.... but ensuring the difference is always £5 in total :-|

    Any help with a formula would be massively appreciated.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width