More than one formula in a cell

E

Eric

Tom,

You can definitely cram two formulas together. However,
it may be tough to them formatted consistently depending
on the results you have.

As a simplistic example, if I put the number 3 in cell A1
and the number 2 in cell B1. The following formula
displays two formula results in cell C1:

=A1*B1&" "&A1+B1

If I wrap the text in that cell, the first result (6) will
appear above the second result (5).

HTH

Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top