Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change positive number to negative number
Hi,
I've searched this board and have tried a few things, no luck yet. I have about 100 rows, in columns A and B there is descriptive text. In column C it is either blank or it contains the text "CR". In column D there is a value (number with 2 decimal places). Column E is blank and available to use for the formula. If there is "CR" in column C, then the value in Column D must be displayed as a negative number. If "CR" doesn't exist then the number should be left positive. How can I do this? I've been working with the ABS and IF functions in Column E but can't get it to work. Please help. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change positive number to negative number
Try the below in cell E1
=IF(C1="CR",-D1,D1) -- Jacob "Angie M." wrote: Hi, I've searched this board and have tried a few things, no luck yet. I have about 100 rows, in columns A and B there is descriptive text. In column C it is either blank or it contains the text "CR". In column D there is a value (number with 2 decimal places). Column E is blank and available to use for the formula. If there is "CR" in column C, then the value in Column D must be displayed as a negative number. If "CR" doesn't exist then the number should be left positive. How can I do this? I've been working with the ABS and IF functions in Column E but can't get it to work. Please help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I subtract a negative number from a positive number? | Excel Discussion (Misc queries) | |||
Change positive to negative number | Excel Worksheet Functions | |||
Converting a negative number to a positive number | Excel Discussion (Misc queries) | |||
Format cells to change a number from a positive to negative | Excel Worksheet Functions | |||
can i change a number formatted as positive to negative in Excel | Excel Discussion (Misc queries) |