Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formula
how do i put more than one formula into a cell?
how do i seperate them from one another? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formula
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formula
Maybe you can explain what you try to achieve?
-- Kind regards, Niek Otten Microsoft MVP - Excel "vtguy09" wrote in message ... | how do i put more than one formula into a cell? | | how do i seperate them from one another? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formula
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formula
A formula can only affect the cell it is in; that is, it can't set a value
in some other cell. So, if I correctly understand what you want to do, you will have to put a formula in that "next cell" which looks at what was selected from the drop down (in other words, what the value is of that cell) and sets its own value accordingly. You still haven't given us enough information for a more complete answer, but the information Chip posted should be of some help in creating the formula for that "next cell". Rick "vtguy09" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |