D Dave Mar 7, 2009 #2 Hi, No, but in effect, using a coditional formula, such as IF, gives you the ability to put more than one formula in a cell, depending on conditions you set. eg IF(A1=1, B1+C1,B1+D1) Regards - Dave
Hi, No, but in effect, using a coditional formula, such as IF, gives you the ability to put more than one formula in a cell, depending on conditions you set. eg IF(A1=1, B1+C1,B1+D1) Regards - Dave
G Gord Dibben Mar 7, 2009 #3 No more than one formula per cell. You can use more than one function or multiples of the same function in a cell formula but it would still constitute "one formula". Show us what you would like to do and I'm sure someone will assist. Gord Dibben MS Excel MVP On Fri, 6 Mar 2009 16:57:00 -0800, Excel User <Excel
No more than one formula per cell. You can use more than one function or multiples of the same function in a cell formula but it would still constitute "one formula". Show us what you would like to do and I'm sure someone will assist. Gord Dibben MS Excel MVP On Fri, 6 Mar 2009 16:57:00 -0800, Excel User <Excel
S Shane Devenshire Mar 7, 2009 #4 Hi, Why don't you tell us what you are really trying to do. There are VBA ways to handle some of the types of problems.
Hi, Why don't you tell us what you are really trying to do. There are VBA ways to handle some of the types of problems.
F francis Mar 7, 2009 #5 Hi Depending on what you want to achieve, there's would be a possibility to have formulas within a formula, this is still consider as only one formula -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis
Hi Depending on what you want to achieve, there's would be a possibility to have formulas within a formula, this is still consider as only one formula -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis