title: How to make my number turn positive/negative based of D/C column?
body: <p>I am trying to find a proper formula in excel that will allow my number to turn positive/negative based on a drop list containing Debit and Credit option. (ex. In cell B7-B45 I have a drop list for choices Debit and Credit only. In cell E7-E45 is the amount column. So lets say the user types in an amount in <strong>"E7"</strong>, I want that number to change to a <strong>"negative"</strong> if they choose <strong>"Credit"</strong> from the drop list. But, if they choose <strong>"Debit"</strong> from the drop list the number they typed in remain <strong>"positive"</strong>.)</p>