 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / April 2007Can 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. 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  SignatureRegards, Peo Sjoblom > 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. This didn't work either but I figured out what I needed to do...thank you! > Do you mean combine as 2 different results with text in-between? > [quoted text clipped - 8 lines] > > =SUM(D30-D29) and C28*1.5 and have the results combine in the one cell. > > Please advise. Can you share with us what worked since all of us seem to have misunderstood you? SignatureRegards, Peo Sjoblom > This didn't work either but I figured out what I needed to do...thank you! > [quoted text clipped - 12 lines] >> > =SUM(D30-D29) and C28*1.5 and have the results combine in the one cell. >> > Please advise. 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. > 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. This didn't work either but I figured out what I needed to do...thank you! > What do you mean by "combine"? > [quoted text clipped - 10 lines] > > =SUM(D30-D29) and C28*1.5 and have the results combine in the one cell. > > Please advise. 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 > 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. This didn't work either but I figured out what I needed to do...thank you! > 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 [quoted text clipped - 15 lines] > > =SUM(D30-D29) and C28*1.5 and have the results combine in the one cell. > > Please advise. Is the result to be: =(D30-D29)+C28*1.5 ???? no need to use SUM > 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. This didn't work either but I figured out what I needed to do...thank you! > Is the result to be: > [quoted text clipped - 8 lines] > > =SUM(D30-D29) and C28*1.5 and have the results combine in the one cell. > > Please advise. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.