I am having trouble finding the right formula to use in excel when it comes to the value showing in a certain cell. I am running into the problem in cell C. For example, cell C_ is positive, I then want cell E_ to equal C_ x D_, if it is negative, I want it to equal D_. (Note: I would like to input this cell into a whole column to continue to do the math for me)
The same issue in reverse which might be the same formula. If cell C_ is negative, then E_ equals D_, but if C_ is positive, then F_ equals D_.
Basically I have either a positive or negative value in cell C, cell D is a dollar amount, cell E is a dollar amount and cell F is a dollar amount as shown below. I am looking for 2 separate formulas (I think). One for Column E and One for Column F that will take into account if C is positive of negative first, if positive then do this, if negative, then do this.
<tbody>
</tbody>
The same issue in reverse which might be the same formula. If cell C_ is negative, then E_ equals D_, but if C_ is positive, then F_ equals D_.
Basically I have either a positive or negative value in cell C, cell D is a dollar amount, cell E is a dollar amount and cell F is a dollar amount as shown below. I am looking for 2 separate formulas (I think). One for Column E and One for Column F that will take into account if C is positive of negative first, if positive then do this, if negative, then do this.
-1.10 | 50 | E | F |
1.27 | 50 | E | F |
1.95 | 50 | E | F |
-1.52 | 50 | E | F |
<tbody>
</tbody>