| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Attaching formula to cells
If Sheets(“Sheet1”).Range(“L1”) 0 Or Sheets(“Sheet1”).Range(“L1”) < 5 Then Sheets(“Sheet1”).Range(“M1”) = 4 :End If the above is 4 or < 20 Then M1 = 5 If the above is 19 or < 120 Then M1 = 6 If the above is 119 Them M1 = 7 The above are the conditions that I want to set so that the value that appears in column M is dependant on the value that is entered in column L. How do I write the formula? How do I attach it to all the rows in column M? I need this because the value that appears in column M will be used as the column number that I will use in a VLOOKUP table. -- grahammal ------------------------------------------------------------------------ grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336 View this thread: http://www.excelforum.com/showthread...hreadid=520529 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
Threaded Mode
