naiveprogrammer

Posts: n/a

Negative Number put in a certain column in a different sheet.

If in Sheet1 A2 is a negative number put in A2 in Sheet2. If in Sheet1 A2 is
a positive number put in A3 in Sheet2.

How can I do this with a formula???

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
Running total w/2 columns - Excel	Anna / Ideal	Excel Worksheet Functions	14	August 10th 05 04:28 PM
Lookup Table Dilemma	Karen	Excel Worksheet Functions	2	June 10th 05 08:22 PM
How do I sort a column a unique number?	ChelleA	Excel Worksheet Functions	7	February 19th 05 10:38 AM
How do I enter a negative number in unit price column?	389Shell	Excel Discussion (Misc queries)	5	February 18th 05 10:58 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 05:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us