Excel Formulas

[Excel User]

Can you enter more than one formula in a cell (in Excel)?

 

[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

 

[Gord Dibben]

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

 

[Shane Devenshire]

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.

 

[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