I think I did not explain my self very well, When

A1=VALUE
B1=INTEREST RATE
C1=COST TO SELL
D1=(result) it should be ASSET INCOME the result of the value*interest rate
- cost to sell = asset income. This number can not be negative

"Frances C" wrote:

I need a formula that can be use for different kind of asset calculations for
example

a 401k that has a value of $10,000.00 and is multiply by interest rate of
2% and I need to subtract $1000.00 for cost to sell (sometimes that cost to
sell is also presented as 10% instead of $1000.00)

I also have a real estate with a value of $200,000.00 to be mutiply by
interest rate of 0% and to subtract a cost to sell of $150,000.00

Another one is a Saving accont a value of $500.00 and is mutiply by interest
rate of 3% with $0.00 cost to sell

I have try some formulas, I really need one that can work with all the
problems.

a1=value b1=interest rate c1=cost to sell d1=where the formula goes
(answer)

Thanks