| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
do you mean something like this: =IF(ISBLANK(C2),FORMULA WITHOUT TEST,FORMULA WITH TEST) where C2 is the cell that holds the test score. If that cell is blank, the formula for scoring without the test is used, else the formula with the test is used. Is this what you are looking for? -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=472970 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average student grades | New Users to Excel | |||
| Counting number of grades in a row | Excel Worksheet Functions | |||
| Do any of the Grade book templates using Excel average grades? | Excel Discussion (Misc queries) | |||
| Vlookup student grades | Excel Discussion (Misc queries) | |||
| Converting Letter Grades to Numeric | Excel Worksheet Functions | |||
Threaded Mode
