| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change a currency number display
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change a currency number display
Say A1 has your negative number then in A2 enter the below =ABS(A1)* your figure here VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=567609 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change a currency number display
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). 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change a currency number display
=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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Change cell color if it is the lowest number of a group? | Excel Discussion (Misc queries) | |||
| Change number when you open the excel template | Excel Discussion (Misc queries) | |||
| adding a number to every change in value | Excel Discussion (Misc queries) | |||
| How do I display an insignificant 0 at the beginning of a number | Excel Discussion (Misc queries) | |||
Linear Mode
