Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 a third column and put this in that column:


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

Your Answer


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.