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

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Cumulative formula for word table 0
Change positive to negative number 3
Excel does not accept text format! 0
Subtracting positive amts from negative and positive from positive 3
Program buttons to create a word document 0
Dealing with the error: unable to filter on excel hc home school 0
How to change numbers from positive to negative. 2

Top