FreePint: Join
Join FreePint and receive the Newsletter every two weeks for free.
Join now »
|
|
|
If you find FreePint useful, please supply
a testimonial »
|
|
FreePint Family:
Monthly magazine reviewing business information products »
Articles, tools, and a monthly magazine, to give you practical help with information skills »
Recruit for information-related roles, or find your next challenge. »
Daily update of web-based resources »
Daily update of free, full-text reports »
|
|
|
|
Home > Forum > Bar > Message |
|
|
Join FreePint and receive the twice-weekly Bar Digest and twice-monthly tip-packed Newsletter. It's free. [ more ]
|
|
|
|
The FreePint Bar is generously sponsored by Dow Jones Factiva.
|
|
|
| Start New | Message Index | Flat View |
| Excel Formulas |
| Author: | Janet |
| Date: | Thursday, 20th Jun 2002 19:06 |
| Views: | 5,042 (excluding Digests and RSS feeds) |
| Category: | Computers and Software | | URL: | http://www.freepint.com/go/b18400 |
|
|
I need to know how to take the data from a cell in one worksheet and have it placed in one of two cells based on the data...example less than 4 would go in one cell and 4 or greater in another cell. Is this possible? |
|
| Start New | |
| Topic |
Author |
Date |
ID |
 | Excel Formulas | | I need to know how to take the data from a cell in one worksheet and have it placed in ... |
|
Janet |
20/06/02 19:06 |
18400 |
 | Re: Excel Formulas | | I would do as Stuart Cliffe has suggested with one possible exception. If you don't want to see strings of ... |
|
Henry Haszler |
22/06/02 03:54 |
18429 |
| | Re: Excel Formulas | | There are quite a few reference works around for MS, but I will answer your specific instance.
This sounds like the ... |
|
Paul |
21/06/02 12:58 |
18416 |
|
Paul |
21/06/02 13:01 |
18417 |
| | Re: Excel Formulas | | In the each of the two destination cells you need a formula like the following:
Assuming that the original cell in ... |
|
Tana |
21/06/02 12:48 |
18415 |
| | Re: Excel Formulas | | Don't know a way offhand of 'sending' a value from one cell to one of two different destinations, without running ... |
|
Stuart Cliffe |
20/06/02 23:27 |
18406 |
|
Janet |
21/06/02 14:56 |
18426 |
| | Re: Excel Formulas | | Check out the following two web sites...
Mr. Excel
http://www.mrexcel.com/
Excel newsgroups
http://www.j-walk.com/ss/excel/xlnews.htm
I have always received excellent help when I posted to these.
Good luck.
|
|
Celeste Smith |
20/06/02 20:56 |
18401 |
Please note: The reply form is not showing because the posting is older than six months or the thread is locked. Please start a new topic or contact the forum administrator.
|
|
