change a currency number display

[wilywayne]

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?

 

[VBA Noob]

Say A1 has your negative number then in A2 enter the below

=ABS(A1)* your figure here

VBA Noob

 

[stend3]

Use the absolute value function around the cell reference in the
formulas - it converts negative numbers to positive numbers. Instead
of =A1 * B1, the formula would read =A1 * ABS(B1).

 

[tim m]

=ABS(A1)

If you post your formula we can show you how to incorporate the ABS function
into it.

 

[wilywayne]

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....