View Single Post
  #3   Report Post  
Biff
 
Posts: n/a
Default

Hi!

Subtract from the total kwh, the known kwh used by the 2
tennants. The result you get will be the kwh used by the
third tennant.

Divide the total kwh by the kwh for each tennant. This
will return each tennants percentage of kwh used.

Multiply each tennants percentage used by the total bill
amount.

Biff

-----Original Message-----
How would I find or make a spreadsheet for splitting an

electric utility bill
among three tenants? The knowns are the total kwh used,

the total bill and
the number of KWH used by two of the three tenants.

Thanks!
.