on sheet 6, of the spreadsheet, i have to calculate the number of units a course is. Now if the course code contains 3 then its 3 units, if its 6 its 6 units, if the course code is blank then the number of units should be blank. I cant seem to get a number value for the number of units without having to use vlookup. Any help would be greatly appreciated.
I don't really understand the question... perhaps you want to use SUMIF ?
(a SUMIF will of course return 0 for blank... assuming 0 is never a valid result you could use a Custom Number Format of [=0]"";General to have 0 display/print as blank)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
will the course have other numbers include the 3 or 6? or will it just be a cell with a 3 or 6 or blank? could you give us an example of what the cell would like?
Happy Excel'ing!
Not sure that I understand the question fully, but other than a different look up formula, such as index/match, there is no other way to return a matching value for a given course. (Now becomes a matter of formula preference)I cant seem to get a number value for the number of units without having to use vlookup.
Anyway, your existing formula needs to use absolute references to the table. Note the use of the $ symbol in the range references.
=IF(A2="","",VLOOKUP(A2,$A$28:$B$33,2))
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
thanks for the help, ok what i basically mean is that that it can either be 3, 6, or blank. So if CS 1TA3 is blank then the number of units should be blank. I want to get the number of units without using Vlookup. I think this is possible if you look at the course code 1ta3 means 3 units, 1ta6 would mean 6 units, and blank would mean blank. I just cant seem to figure out a formula for this.
How aboutin B2 and copied down.
Please Login or Register to view this content.
BTW if you want your Semester Average to display as a percentage followed by the grade you could usePlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks