change a currency number display
THANKS FOR THE HELP...THE FORMULA THAT I USED IS =PMT(L42/23,L43,M41)
THE L42/12 IS THE MONTHLY INTEREST RATE, L43 IS THE TERM IN MONTHS AND M41
IS THE DOLLAR AMOUNT....
"tim m" wrote:
=ABS(A1)
If you post your formula we can show you how to incorporate the ABS function
into it.
"wilywayne" wrote:
I have created a formula to calculate a real estate payment, which returns a
negative number as the result. I need to change the negative number to a
postive number to use in other formulas. How do you do it?
|