in formulas how can I use contents of a cell?

Posted to microsoft.public.excel.worksheet.functions

Soo

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Showing the contents of a cell based on another cell	Daminc	Excel Worksheet Functions	9	November 10th 05 08:39 AM
Problem with formulas changing cell reference	janicesweet	Excel Discussion (Misc queries)	1	August 2nd 05 06:23 PM
change cell shading whenever contents different from previous cell	zooeyhallne	Excel Discussion (Misc queries)	3	June 6th 05 09:59 PM
Formula to return cell contents based on multiple conditions	Bill	Excel Worksheet Functions	3	January 19th 05 09:59 AM
Cell contents vs. Formula contents	Sarah	Excel Discussion (Misc queries)	3	December 15th 04 06:02 PM

All times are GMT +1. The time now is 08:48 PM.

Menu

About Us