Biff
Flip your quotient over. The way you have it results in each person
having more than 100% of the total. HTH Otto
"Biff" <[email protected]> wrote in message
news:[email protected]...
> 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!
>>.
>>