excel formula
how do i put more than one formula into a cell?
how do i seperate them from one another? |
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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 06:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com