On Sep 29, 1:46 pm, Frances C
wrote:
I need a formula that can be use for different kind of asset
calculations

I feel that I must not understand the problem you are trying to solve
because the financial arithmetic you want to perform seems too
rudimentary. So forgive me if my solution misses the mark entirely.


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)

The parenthetical requirement is something of a challenge.
Ostensibly, there is no discernible difference between $1000 and 10%.
You can format 10% and $0.10; and you can format $1000 as 100000%.
(Did I add enough zeros?)

Perhaps it will be sufficient to assume that percentages are always
less than 100% and dollar values are always more than $1. If you
cannot live with that assumption, then it will be necessary to add a
cell to indicate what kind of number you have in the "cost" cell (C1).


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
[....]
a1=value b1=interest rate c1=cost to sell
d1=where the formula goes (answer)

The formula in D1 could be:

=round(A1*(1+B1) - if(C1<1, A1*C1, C1), 2)

I have made some assumptions about your requirements.

You say that you want the value to be "multiplied by the interest
rate". Ostensibly, that would be A1*B1. But then you say that you
want to subtract the cost. In the first example, that would result in
a negative value because 2%*10000 - 1000 is 200 - 1000. So I ass-u-me
you mean that you want the value __increased__ by the interest rate;
hence A1*(1+B1).

Also, you say that sometimes the cost is "a percentage". A percentage
of what? Your example is deceptive: you write "10% instead of
$1000", where the value is $10,000. That might suggest that you mean
"a percentage of the value before adding interest". That is what I
ass-u-me for the formula above.

But I would expect you mean "a percentage of the increased value,
after adding interest". In that case, the formula might be:

=round(A1*(1+B1) - if(C1<1, A1*(1+B1)*C1, C1), 2)

Alternatively:

=round(if(C1<1, A1*(1+B1)*(1-C1), A1*(1+B1)-C1), 2)

HTH.