Change positive number to negative number

A

Angie M.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change positive to negative number 4
Subtracting positive amts from negative and positive from positive 3
making a # value positive or negative based on contents of another 3
How to change numbers from positive to negative. 2
How to count the maximum number of consecutives? 9
CONDITIONAL FORMATTING & NEGATIVE VALUES 1
make a positive number to negative 2
column of negative numbers into positive numbers 2

Top