lesser-equity

Magazine
Go Back   Computer Juice > Computer Software > Office Suites & Applications

Register


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. ...


Reply
 
Thread Tools
  #1  
Old 4th Jan 2008, 04:56
New Member Group
 
Posts: 2
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>
  #2  
Old 5th Jan 2008, 17:19
Donor Group
 
Posts: 533
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.
__________________
Woah! You found my secret sentence! lol, n00b.
__________________

My System: =/

Processor(s):
AMD 64x2 6000+
Motherboard:
Asus M2N32 SLI DELUXE WIFI
RAM Memory:
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
  #3  
Old 6th Jan 2008, 14:58
New Member Group
 
Posts: 2
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>
Reply

Donate

Register

Bookmarks

Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent Help needed XgenAdam General Hardware Chat 2 23rd Dec 2007 15:42
Urgent help needed bigblair Windows Operating Systems 6 1st Nov 2007 03:30
Urgent help needed for Word 2007 WildDart Office Suites & Applications 2 24th Oct 2007 17:57
Urgent Help Needed Insomnia General Hardware Chat 14 9th Oct 2007 04:06
Exel spreadsheet help needed demo Office Suites & Applications 19 17th Sep 2007 13:17
Thread Tools




Arabic Bulgarian Chinese (Simplified) Chinese (Traditional) Croatian Czech Danish Dutch English Finnish French German Greek Hebrew Hungarian Italian Japanese Korean Latvian Lithuanian Norwegian Polish Portuguese Romanian Russian Serbian Slovak Spanish Swedish Thai Turkish Ukrainian

Copyright ©2006 - 2009 Computer Juice.

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