Can multiple formulas be inserted in a single cell?

  • Thread starter Thread starter Ivan Koh
  • Start date Start date
I

Ivan Koh

Hi all,

is it possible for multiple formulas to be inserted into a cell?

I currently have a cell in worksheet a that already has a formula inserted
in it. However, is it possible to put another formula in place to convert an
initial result, e.g '0' to then start another formula?

Ivan
 
Hi,

The answer is maybe!!. You can have 2 formula in a cell and here's and example

=22/7 &" " & 2^6

What you can't do is have the second formula take the result of the first.

Perhaps you mean an if statement that evaluates something then can do
different things depending on the outcome

=if(a1=1,do this, do something else)

Give an example of what you trying to do.

Mike
 
In addition to what Mike H said, you can use a formula as a "variable" within
a formula. You mentioned "converting" an initial result.

Lets say that you have a formula in a cell that needs to use a value twice
the size of the value in A1 somewhere for some reason, then

= (X1 + B4) / (Z3 * (A1*2))

or maybe you need to use a value of 2 if A1 = "Good" and 3 if A1 doesn't
equal "Good"
= (X1 + B4) / (Z3 * (If(A1="Good",2,3) * 2))

If you can be more specific with that part of your question, we can probably
be more specific in our answers.
 
Back
Top