View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Soo
 
Posts: n/a
Default 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?