how aboutOn 2002-02-27 06:01, Anonymous wrote:

I'm trying to figure out a formula that will calculate the following problem: I want to split a certain bill between tenants based on their square footage, but some tenants need to pay double. For example:

I have $200.00 to charge out to tenants A & B, based on the square footage of their leases. Tenant A has 75 square feet, Tenant B has 25 square feet. I can't just charge $2 a square foot; Tenant B needs to pay double what Tenant A pays. Can anyone help?

=A2/3*2 For b

and

=+A2/3*1 For a?

good luck

[ This Message was edited by: IML on 2002-02-27 06:27 ]

## Like this thread? Share it with others