Forum Discussion
Excel Formula Help Please
I have a cell with text and a dollar amount in parenthesis in a cell and an adjacent cell with "$0.00". If the cell shows "$0.00" I want to extract the dollar value in the parenthesis and not the other text, otherwise ignore.
| SPIL - ($47,394.64) | $5,520.00 | |
| SPIL - ($47,394.64) | $0.00 | $47,394.64 |
Any help would be greatly appreciated.
No RepliesBe the first to reply
