Financial Calculation needed

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hello...I have a worsheet that has one row of data. One
field named Insurance or Guarantee is changed often based
on whether it is Insurance or Guarantee. I have another
cell that I want to perform a calculation based on what
is typed in the Insurance or Gurantee field. If the
field says Insurance then I need for .4 to be subtracted
from the interest rate (@B2). If it is a Guarantee then
I need .35 to be subtracted from the interest rate
(@b2).

Any help here?

thank you
 
Another option might be to pull the common B2 out. (Also assuming only I or
G in A2)

=B2-5%*(A2="Insurance")-35%
=IF(A2="Insurance", B2-0.4, B2-0.35)
Click to expand...

Dana DeLouis
 
Back
Top