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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula dependent on a cell entry
hi clatters
why don't you do this: =if(sheet1!A1 = "H";Lookup for H; lookup for F) greetings Carlo "clatters69" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula dependent on a cell entry
Say cell for F/H is A1, then insert in B1: =IF("A1"="F",formula for F,
formula for H) Regards, Stefi €˛clatters69€¯ ezt Ć*rta: 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? |
Reply |
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 |