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!

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),"-")

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

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.

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