FreePint Bar: Excel Formulas

Subscribe
Receive the free twice-monthly FreePint Newsletter.
Join now »

My Account »

If you find FreePint useful, please supply a testimonial »

Home > Forum > Bar > Message

Excel Formulas

Share this posting:

RSS Feeds Twitter Feed

... or subscribe to the FreePint Newsletter.

Scroll down to read the full posting

« Return to the FreePint Bar Message Index

FreePint Research Report: Information Governance Policies and Priorities: This was the first time FreePint Research brought together various areas of information governance -- records management, IP protection, copyright risk management, etc. -- into a single research project.
Find out more »

The FreePint Bar is free
thanks to our sponsors:

Message Index | Flat View

Share this posting:

Featured Posting:

[FreePint] Fighting the good fight for copyright

Popular Bar posts
(60 days):

Return to the
Message Index

Excel Formulas

Author:

Janet

Date:

Thursday, 20th Jun 2002 19:06

Views:

6,158 (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?

blog comments powered by Disqus

Topic

Author

Date

•	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

•	Re: Excel Formulas
	Oops, didn't see query was already answered!

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

•	Re: Excel Formulas
	Thanks so much for your help

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