| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
| Dual Screens | Excel Discussion (Misc queries) | |||
| How do I create a dual axes column chart in Excel | Charts and Charting in Excel | |||
| ="Z" dual use? | Excel Worksheet Functions | |||
| How do you create dual drop down menus in excel 2000? | Excel Discussion (Misc queries) | |||
Linear Mode
