Go Back   Computer Juice > Computer Software > Office Suites & Applications
Register Members New Posts Donate Unanswered Posts Site Spy Search


Reply
 
Thread Tools
  #1  
Old 04-01-2008, 10:56 AM
No Avatar
CJ New Member
 
CharlesCrisp is offline
 
Join Date: Jan 2008
Last Online: 06-01-2008 08:58 PM
Posts: 2
iTrader: (0)
CharlesCrisp is on a distinguished road
Default Urgent Help needed with Spreadsheet

Im doing a v-look up table, and Im trying to figure out what I need to do to correct my current formula as it is not working. I've done everything apart from 1 thing (I think) in the formula and I don't know what to put?! :S It's the col_index_num.
Heres a pic:

<a href="http://s198.photobucket.com/albums/a...t=spread-1.jpg" target="_blank"><img src="http://i198.photobucket.com/albums/a...y/spread-1.jpg" border="0" alt="Photobucket"></a>
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #2  
Old 05-01-2008, 11:19 PM
No Avatar
CJ Banned Member
 
Gazmondo is offline
 
Join Date: Dec 2007
Last Online: 21-07-2008 04:59 PM
Age: 19
Posts: 555
iTrader: (1)
Gazmondo is on a distinguished road
Default Urgent Help needed with Spreadsheet

H2 to H10 are formatted as text, and E9 is a number.

Excel does not recognise 1 to 5 as 1 or 2 or 3 or 4 or 5. It simply sees it as 1 to 5.

To rectify your table, the simplest method (there will be an advanced more complicated solution but it is beyond my excel knowledge) would be to re-arrange your table to this:

Total Marks - Grade
1 - F
2 - F
3 - F
4 - F
5 - F
6 - E
7 - E
8 - E
9 - E
10 - E

etc etc.

This method would work but it is by no means the best.
__________________

My System: =/

CPU(s):
AMD 64x2 6000+
Motherboard:
Asus M2N32 SLI DELUXE WIFI
RAM:
Corsair XMS2 DDR800 CL4 2048MB
Graphics Card(s):
BFG 8800GTS 320MB OC2
Sound Card:
Onboard
Hard Drive(s):
2x36gb RAID0 / 200GB / 500GB
Optical Drive(s):
CDRW + DVD-RW [dual layer]
Case / PSU:
CM Stacker832 / Silverstone DA750
Cooling:
Zalman CNPS9700NT
Network / Internet:
dual gigabit / 20mb Cable
Monitor(s):
19" HannsG
Operating System(s):
XP Pro 32Bit

Want your system info in your signature?
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #3  
Old 06-01-2008, 08:58 PM
No Avatar
CJ New Member
 
CharlesCrisp is offline
 
Join Date: Jan 2008
Last Online: 06-01-2008 08:58 PM
Posts: 2
iTrader: (0)
CharlesCrisp is on a distinguished road
Default Urgent Help needed with Spreadsheet

Thanks very much for your help! However now it performs its function BUT.... it only calculates what grade someone should get in E9 onwards. I want it to calculate the G9 onwards aswell. However when I type E9:G9 in, it includes the yes/no box aswell, and the formula dusnt function. How do I avoid this?

<a href="http://s198.photobucket.com/albums/a...t=untitled.jpg" target="_blank"><img src="http://i198.photobucket.com/albums/a...y/untitled.jpg" border="0" alt="Photobucket"></a>
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote

Please support this forum, donate towards our running costs.


Reply


Thread Tools

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent Help needed XgenAdam General Hardware Chat 2 23-12-2007 09:42 PM
Urgent help needed bigblair Windows Operating Systems 6 01-11-2007 09:30 AM
Urgent help needed for Word 2007 WildDart Office Suites & Applications 2 25-10-2007 12:57 AM
Urgent Help Needed Insomnia General Hardware Chat 14 09-10-2007 11:06 AM
exel spreadsheet help needed demo Office Suites & Applications 19 17-09-2007 08:17 PM


Copyright ©2006 - 2008 Computer Juice.

Powered by vBulletin® Copyright ©2000 - 2008 Jelsoft Enterprises Ltd. SEO by vBSEO ©2008, Crawlability, Inc.