| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
in formulas how can I use contents of a cell?
I need a formula to say:
if G2=10 keep contents of I2 in I2 BUT if G2=11 move the contents of I2 to J2 BUT if G2=12 move contents of I2 to K2 Can anyone help, please? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
in formulas how can I use contents of a cell?
You can't do it the way you want. A function can only return a result to the
cell it is in. For instance, in J2 you could say =IF(G2=11,I2,"") but the value would still be in I2 as well. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Soo" wrote in message ... I need a formula to say: if G2=10 keep contents of I2 in I2 BUT if G2=11 move the contents of I2 to J2 BUT if G2=12 move contents of I2 to K2 Can anyone help, please? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
in formulas how can I use contents of a cell?
Is there a way to move the contents rather than just copy them? I don't mind
doing the formula per column. So: [putting formula in J2] if G2=11 move the contents of I2 to J2 "Bob Phillips" wrote: You can't do it the way you want. A function can only return a result to the cell it is in. For instance, in J2 you could say =IF(G2=11,I2,"") but the value would still be in I2 as well. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Soo" wrote in message ... I need a formula to say: if G2=10 keep contents of I2 in I2 BUT if G2=11 move the contents of I2 to J2 BUT if G2=12 move contents of I2 to K2 Can anyone help, please? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
in formulas how can I use contents of a cell?
No, not with a formula, as I said, a function can only return a result to
the cell it is in, it cannot change any other aspect of the worksheet, be that values in other cells, or colours in other cells, etc. You could do it with VBA. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Soo" wrote in message ... Is there a way to move the contents rather than just copy them? I don't mind doing the formula per column. So: [putting formula in J2] if G2=11 move the contents of I2 to J2 "Bob Phillips" wrote: You can't do it the way you want. A function can only return a result to the cell it is in. For instance, in J2 you could say =IF(G2=11,I2,"") but the value would still be in I2 as well. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Soo" wrote in message ... I need a formula to say: if G2=10 keep contents of I2 in I2 BUT if G2=11 move the contents of I2 to J2 BUT if G2=12 move contents of I2 to K2 Can anyone help, please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Showing the contents of a cell based on another cell | Excel Worksheet Functions | |||
| Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
Linear Mode
