Can multiple formulas be inserted in a single cell?
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
"Ivan Koh" wrote:
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
|