Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing cell contents with different reference cells
Hi
Hope someone can suggest a solution to this apparently simple problem. I am developing a spreadsheet to evaluate student performance. In one cell a computer predicted score is automatically generated, the teacher may or may not enter their predicted score in the next cell. Finally the actual score is entered in a third cell. I need a formula to compare the actual score with the computer generated score unless there is a value in the teacher prediction cell in which case I want to compare that one. A1 = Computer prediction B1 = Teacher prediction C1 = Actual Score so if B1 is blank, compare C1 to A1 however if there is a value in A1 and B1, compare C1 to B1 Hope this makes sense Thanks in anticipation Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Using a cells contents to reference a sheet. | Excel Worksheet Functions | |||
Using cell contents to reference worksheet names | Excel Discussion (Misc queries) |