| 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 OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200705/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
testing data in above cell, and choosing column to copy from
i figured it out myself, and it is
=IF(B8=G8,G9,IF(B8=H8,H9,IF(B8=I8,I9,IF(B8=J8,J9,0 )))) to make it easier to view it is =IF(B8=G8,G9, IF(B8=H8,H9, IF(B8=I8,I9, IF(B8=J8,J9, 0)))) OTWarrior wrote: 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 OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200705/1 |
| Reply |
| 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 | |||
| testing data in above cell, and choosing column to copy from | Excel Programming | |||
| Copy data in column based on cell value | Excel Programming | |||
| Copy data in column based on cell value | Excel Programming | |||
Hybrid Mode
