Run different command depending on cell describing content

**kayswiss** · 10-04-2012, 12:59 AM

Hello,
Basically I'm trying to make a Excel spreadsheet that'll help me track all my marks. However, the thing is, my teachers don't simply average all the assignments, tests, quizzes and whatever. They take, for example, 75% of your test/quiz marks, and 25% of your homework. I get the feeling that I should be using an IF statement, but I'm not quite sure how to implement it.

Table structure:

ID	Assignment	Mark	Points Possible	Type
1	Lab 4.5	46	51	lab/project/homework
2	Chapter 8 Test (omit 8.3)	54	60	test/quiz

Basically, because tests and homework are weighted differently, I can't simply sum everything. I need to somehow check whether each row's "Type" cell matches "lab/project/homework" or "test/quiz", and then adjust the formula.

This is what I have so far:

=IF(Table146[Type]="lab/project/homework",Table146[[#Totals],[Mark]]/Table146[[#Totals],[PP]]*0.25)*100

But I'm not sure how to make it loop through this check through each row of my table.

Thanks, your help is much appreciated!

**protonLeah** · 10-04-2012, 01:11 AM

To Attach a File (workbook, not a picture):

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.