| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Formulas do not work in excel. | Excel Discussion (Misc queries) | |||
| IF/AND formulas within excel | Excel Discussion (Misc queries) | |||
| duplicating excel formulas | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
