Exclude non-numeric data from calculation
 

I have 3 columns: units, numeric grade, and points.
Points are calculated by multiplying units by numeric grade.
Then I divide total points by total units.

Occasionally, I have a non-numeric grade. When that's the case, I want
to exclude the units from any calculation.

How would I write my formula(s) to recognize this condition?

Basically, I want to say IF(range<a number,"",range). Which also
brings up the question, is it even possible to use the range operator
in an IF worksheet function, thereby forcing Excel to consider each
number in the range for any given condition?

Thanks in advance! I hope you're less confused than I am!


--
jostermi
------------------------------------------------------------------------
jostermi's Profile: http://www.excelforum.com/member.php...o&userid=26561
View this thread: http://www.excelforum.com/showthread...hreadid=398320

Try with isnumeric function, returns a boolean value. True if it is a
number


--
baldomero
------------------------------------------------------------------------
baldomero's Profile: http://www.excelforum.com/member.php...o&userid=25680
View this thread: http://www.excelforum.com/showthread...hreadid=398320