Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
#2
![]() |
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Exclude hidden data from summary totals | Excel Discussion (Misc queries) | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |