Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jostermi
 
Posts: n/a
Default 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

  #2   Report Post  
baldomero
 
Posts: n/a
Default


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 01:43 AM
Exclude hidden data from summary totals XVOTE Excel Discussion (Misc queries) 2 June 3rd 05 06:26 AM
Removing blank rows in a worksheet Louise Excel Worksheet Functions 6 May 26th 05 03:21 PM
Combining data (numeric format) in multiple cells into one cell (t GNAC SID Excel Discussion (Misc queries) 2 February 7th 05 05:09 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 12:56 PM


All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"