Perhaps something like this, using ISNUMBER:
In E1: =IF(ISNUMBER(A1),A1*SUM(B1:C1),"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kwokman3" wrote:
Is there a way for excel to identify cells with number in them, then extract
the numerical data from the cell and use it in another formula?
--
Kwokman