| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula in excel to change - to +
What is the formula to indicate the negative values as positive value.
For example: How to display -32 as 32 in a cell. Note: If the cell already has positive value (32), then retain the same. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula in excel to change - to +
The formulae would be
=if(A1<0,A1*-1,A1) I hope the same works. Regards Raj "mrbalaje" wrote: What is the formula to indicate the negative values as positive value. For example: How to display -32 as 32 in a cell. Note: If the cell already has positive value (32), then retain the same. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula in excel to change - to +
Hi mrbalaje,
Try =ABS(A1) HTH Martin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why Excel does automatically change the formula? | Excel Worksheet Functions | |||
| Change height of the Formula Bar in Excel? | Excel Discussion (Misc queries) | |||
| how do i enter a formula in excel that will change a cell value | Excel Worksheet Functions | |||
| How can I change the formula bar in excel 2003? | Excel Discussion (Misc queries) | |||
| Excel formula to change a value every 2 weeks | Excel Discussion (Misc queries) | |||
Linear Mode
