ExcelBanter - Excel Formulas using "IF"

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Formulas using "IF" (https://www.excelbanter.com/excel-discussion-misc-queries/3594-excel-formulas-using-%22if%22.html)

Corey Brock

Excel Formulas using "IF"

If I enter the word "bounced in one cell can I trigger a
value ($500.00) to become a negative number (-$500.00)?

Regrads,
Corey Brock

Dave Peterson

Maybe you could use a helper cell with a formula:

=if(a1="bounced",-b1,b1)

Corey Brock wrote:

If I enter the word "bounced in one cell can I trigger a
value ($500.00) to become a negative number (-$500.00)?

Regrads,
Corey Brock

--

Dave Peterson

All times are GMT +1. The time now is 06:27 AM.