D1= Total cost
E1= Total KWH
E2=KWH used by two tenants
=D1-(D1*(E2/E1))
Vaya con Dios,
Chuck, CABGx3
"dmcquil" wrote in 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!
|