Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a many long statements converted from text, the credits and debits all are in same column as plain positive amounts, to distinguish the credits to debits the cell next to the amounts shows the word “Db” or “Cr”. I need a formula that convert all the amounts next to the cell with the word “Db” into a negative (i.e. -58.00) without having to manually put a minus (-) in the many hundreds

share|improve this question
add comment

1 Answer

Add a third column and put this in that column:

=IF(B1="Db";-A1;A1)

With A1 being your value and B1 being the column with "Db" or "Cr". Then copy this formula till as far as you need it.

See example here

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.