Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Two formulas in one cell?
Hi everyone, I've done a quick search on the site and cant seem to find an answer so I figure I'd throw it out there for an answer. I am creating a workback and trying to minimize clutter. That said- right now I have a cell that calculates days out from today's date. Within that same cell I want to have days/weeks whereby that individual cell calculates days out and the next formula uses that value and divides by 7 to calculate weeks out using that first formula, with the end value resulting something like: “28 / 4” (days out / weeks out). 28 is the first calculation [=IF(F180,F18-TODAY(),"-")] and 4 representing the the results of the first calculation divided by 7.
Any help would be huge! Many thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two formulas in one cell?
On Mon, 9 Apr 2012 21:32:00 +0000, Tusa123 wrote:
Hi everyone, I've done a quick search on the site and cant seem to find an answer so I figure I'd throw it out there for an answer. I am creating a workback and trying to minimize clutter. That said- right now I have a cell that calculates days out from today's date. Within that same cell I want to have days/weeks whereby that individual cell calculates days out and the next formula uses that value and divides by 7 to calculate weeks out using that first formula, with the end value resulting something like: “28 / 4” (days out / weeks out). 28 is the first calculation [=IF(F180,F18-TODAY(),"-")] and 4 representing the the results of the first calculation divided by 7. Any help would be huge! Many thanks! You can't really use the result of one formula in the next, and display both values. At least, I don't know how using worksheet functions. But you could concatenate the two formulas. Be aware, though, that the result will be a text string; not something easily used in a subsequent formula. e.g: =IF(F180,F18-TODAY(),"-") & " / " & IF(F180,ROUND((F18-TODAY())/7,1),"-") |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two formulas in one cell?
Ron Rosenfeld pretended :
On Mon, 9 Apr 2012 21:32:00 +0000, Tusa123 wrote: Hi everyone, I've done a quick search on the site and cant seem to find an answer so I figure I'd throw it out there for an answer. I am creating a workback and trying to minimize clutter. That said- right now I have a cell that calculates days out from today's date. Within that same cell I want to have days/weeks whereby that individual cell calculates days out and the next formula uses that value and divides by 7 to calculate weeks out using that first formula, with the end value resulting something like: “28 / 4” (days out / weeks out). 28 is the first calculation [=IF(F180,F18-TODAY(),"-")] and 4 representing the the results of the first calculation divided by 7. Any help would be huge! Many thanks! You can't really use the result of one formula in the next, and display both values. At least, I don't know how using worksheet functions. But you could concatenate the two formulas. Be aware, though, that the result will be a text string; not something easily used in a subsequent formula. e.g: =IF(F180,F18-TODAY(),"-") & " / " & IF(F180,ROUND((F18-TODAY())/7,1),"-") Any formula that needs to use the resulting string could wrap it in the VALUE() function so it can be used in calcs. Not sure, though, how it might work in the proposed format. Some parsing methodology would definitely need to be used... -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two formulas in one cell?
On Mon, 09 Apr 2012 22:51:44 -0400, GS wrote:
Any formula that needs to use the resulting string could wrap it in the VALUE() function so it can be used in calcs. Not sure, though, how it might work in the proposed format. Some parsing methodology would definitely need to be used... I believe that the VALUE function, when applied to the fractional format, will try to interpret the string as a date. So, depending on the magnitude of the values, actually the magnitude of the numerator, and probably also depending on the Windows Regional date format settings, the result will be either a !VALUE# error, or an unexpected value. Parsing would be required to use either value in a subsequent formula. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two formulas in one cell?
on 4/10/2012, Ron Rosenfeld supposed :
On Mon, 09 Apr 2012 22:51:44 -0400, GS wrote: Any formula that needs to use the resulting string could wrap it in the VALUE() function so it can be used in calcs. Not sure, though, how it might work in the proposed format. Some parsing methodology would definitely need to be used... I believe that the VALUE function, when applied to the fractional format, will try to interpret the string as a date. So, depending on the magnitude of the values, actually the magnitude of the numerator, and probably also depending on the Windows Regional date format settings, the result will be either a !VALUE# error, or an unexpected value. Parsing would be required to use either value in a subsequent formula. My point exactly, Ron! -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two formulas in on cell based on two numbers in another cell? | Excel Discussion (Misc queries) | |||
Carrying formulas over to new cell when old cell is deleted: possi | Excel Worksheet Functions | |||
How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
change cell value greater than another cell value using formulas | Excel Worksheet Functions |