Excel Formula Help Please

%3CLINGO-SUB%20id%3D%22lingo-sub-1557165%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1557165%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20cell%20with%20text%20and%20a%20dollar%20amount%20in%20parenthesis%20in%20a%20cell%20and%20an%20adjacent%20cell%20with%20%22%240.00%22.%20If%20the%20cell%20shows%20%22%240.00%22%20I%20want%20to%20extract%20the%20dollar%20value%20in%20the%20parenthesis%20and%20not%20the%20other%20text%2C%20otherwise%20ignore.%3C%2FP%3E%3CTABLE%20width%3D%22528%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22260px%22%20height%3D%2230px%22%3ESPIL%20-%20(%2447%2C394.64)%3C%2FTD%3E%3CTD%20width%3D%22106px%22%20height%3D%2230px%22%3E%245%2C520.00%3C%2FTD%3E%3CTD%20width%3D%22161px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22260px%22%20height%3D%2230px%22%3ESPIL%20-%20(%2447%2C394.64)%3C%2FTD%3E%3CTD%20width%3D%22106px%22%20height%3D%2230px%22%3E%240.00%3C%2FTD%3E%3CTD%20width%3D%22161px%22%20height%3D%2230px%22%3E%2447%2C394.64%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1557165%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20-%20formulas%20data%20worksheet%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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. 

0 Replies