Can you create a dual formula?
 

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.

Can you create a dual formula?
 

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

--
Regards,

Peo Sjoblom


"Cryla" wrote in message
...
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.

Can you create a dual formula?
 

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.

In article ,
Cryla wrote:

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.

Can you create a dual formula?
 

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


"Cryla" wrote:

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.

Can you create a dual formula?
 

Is the result to be:

=(D30-D29)+C28*1.5

????

no need to use SUM

"Cryla" wrote:

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.

Can you create a dual formula?
 

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

"Elkar" wrote:

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


"Cryla" wrote:

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.

Can you create a dual formula?
 

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

"Toppers" wrote:

Is the result to be:

=(D30-D29)+C28*1.5

????

no need to use SUM

"Cryla" wrote:

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.

Can you create a dual formula?
 

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

"Peo Sjoblom" wrote:

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

--
Regards,

Peo Sjoblom


"Cryla" wrote in message
...
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.

Can you create a dual formula?
 

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

"JE McGimpsey" wrote:

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.

In article ,
Cryla wrote:

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.

Can you create a dual formula?
 

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

--
Regards,

Peo Sjoblom

"Cryla" wrote in message
...
This didn't work either but I figured out what I needed to do...thank you!

"Peo Sjoblom" wrote:

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

--
Regards,

Peo Sjoblom


"Cryla" wrote in message
...
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.