i have a drop down menu and when you select a drop down i want a message to
appear in the next cell which is working with one function but i have not
been able to combine two together.

"Chip Pearson" wrote:

A cell cannot contain two formulas -- only a single formula can reside in a
cell. However, a single formula can be designed to do multiple tasks. For
example,

=IF(A1=1, formula_1, IF(A1=2, formula_2, formula_3))

will evaluate formula_1 2 or 3 depending on the value of A1. Perhaps you
could provide some additional information about what you are trying to
accomplish.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"vtguy09" wrote in message
...
how do i put more than one formula into a cell?

how do i seperate them from one another?