Can you create a dual formula?

[Guest]

Is it possible to create a cell with 2 different formulas? I need to subtract
one cell from another as well as to multiply a cell by a number. Example:
=SUM(D30-D29) and C28*1.5 and have the results combine in the one cell.
Please advise.

 

[Peo Sjoblom]

Do you mean combine as 2 different results with text in-between?

=D30-D29&" and "&C28*1.5

You might need the text function as well if you need formats like dates or
currency etc

 

[JE McGimpsey]

What do you mean by "combine"?

You could display both results:

=D30-D29 & " " & C28*1.5

Note that the SUM() in your formula isn't necessary.

Note also that the result will be Text, rather than a number.

 

[Guest]

When you say "combine", do you mean show both results side by side? Or add
them together? Also, the use of the SUM function is redundant in your
example, since you're not adding the result of D30-D29 to anything.

Here's a couple options:

To add the results together:
=D30-D29+(C28*1.5)

To show both results side-by-side:
=D30-D29&" "&C28*1.5

HTH,
Elkar

 

[Guest]

Is the result to be:

=(D30-D29)+C28*1.5

????

no need to use SUM

 

[Guest]

This didn't work either but I figured out what I needed to do...thank you!

 

[Guest]

This didn't work either but I figured out what I needed to do...thank you!

 

[Guest]

This didn't work either but I figured out what I needed to do...thank you!

 

[Guest]

This didn't work either but I figured out what I needed to do...thank you!

 

[Peo Sjoblom]

Can you share with us what worked since all of us seem to have misunderstood
you?