PMT Formula using one cell or the other....

[SnowBrian]

Good Morning Team. Im having a hard time describing this formula in google, so had to come here for help. I need a formula that is: A1 - A2 = A3 OR if there is a value in cell B2, then A1 - B2 = A3

I need this formula to have the option of entering a value in A2 or B2 and A3 will only give results if one or the other has a value.

The formula is for a loan amount. If you have a purchase price of $500K (A1) and you want to put down either a flat rate of 5% (A2) OR a straight forward $ amount (B2) (The amount can be any dollar amount. its not about the % anymore. They could put down a $1 or they can put down $20,000.) And then A3 will be the total of either option. The A3 total will then be used in a PMT formula.

I hope I explained that well enough for somebody to help me.

[Special-K]

Is it this?

in A3
=A1-IF(A2<>0,A1*A2,B2)

where A2 is a percentage and B2 is an amount.

[SnowBrian]

I can definitely work with this!!! Thank you Special K.