| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
testing data in above cell, and choosing column to copy from
i have a cell which wil set a value (5, 10, ETC). and depending on this value,
chnage the boxes below it. i currenlty have: =IF(B8=G8,G9,0) which changes the cell is one criteria is met. however i want =IF(B8=G8,G9,0) or IF(B8=j8,j9,0) or IF(B8=h8,h9,0) can this be done in a cell? and if so, what is the syntax for separateing the exprressions ("IF(B8=j8,j9,0)")? -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy last cell with data in column E on one sheet to cell on anoth | Excel Worksheet Functions | |||
| Choosing last set of data in column | Excel Worksheet Functions | |||
| I need data to copy to the next available cell in a column from a macro | Excel Programming | |||
| Copy data in column based on cell value | Excel Programming | |||
| Copy data in column based on cell value | Excel Programming | |||
Threaded Mode
