Ignore Text for Formula
 

I've got a cell that will either produce a numeric vakue as the answer
or subject to an If Statement will produce nothing ie "". I'm using ""
rather than 0 as I don't want it to be visable unless it's a number.

My problem is that I want to use the answer from this cell in further
calcs. The calc is just adding two cells ... but if the answer to the
cell has text then just ignore it and produce the value in the first
cell.

Eg. A1 + A2 = X
Where A2 = Text then = A1

:confused:


--
JohnHill
------------------------------------------------------------------------
JohnHill's Profile: http://www.excelforum.com/member.php...o&userid=25171
View this thread: http://www.excelforum.com/showthread...hreadid=536229

Ignore Text for Formula
 

Eg. A1 + A2 = X
Where A2 = Text then = A1

=if(A2="",A1,A1+A2)


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=536229

Ignore Text for Formula
 

Thanks Dave ... appreciated


--
JohnHill
------------------------------------------------------------------------
JohnHill's Profile: http://www.excelforum.com/member.php...o&userid=25171
View this thread: http://www.excelforum.com/showthread...hreadid=536229