Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula dependent on a cell entry
I am setting up a grade book for test results. I have two levels of test,
Foundation and Higher, with different grade boundaries, hence different LOOKUP formulae. I want to be able to enter either F or H in a cell and then the formula in the cell to the right of it to change depending on whether F or H has been entered, so that F inserts the Foundation LOOKUP formula in the next cell and H inserts the Higher LOOKUP formula in the next cell. The same pupil might sit a different level for a test each time, so it is not as simple as entering a formula for a pupil and sticking to it, the formula must change depending on the F or H entry. Is this possible in Excel 2003? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Formula and or data entry into cell? | Excel Worksheet Functions | |||
Need help with a Multiply Dependent One Cell Formula | Excel Worksheet Functions | |||
Manual or Formula entry in cell. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |