Two formulas in one cell?

[Tusa123]

Hi everyone, I've done a quick search on the site and cant seem to fin
an answer so I figure I'd throw it out there for an answer. I a
creating a workback and trying to minimize clutter. That said- right no
I have a cell that calculates days out from today's date. Within tha
same cell I want to have days/weeks whereby that individual cel
calculates days out and the next formula uses that value and divides b
7 to calculate weeks out using that first formula, with the end valu
resulting something like: “28 / 4” (days out / weeks out). 28 is th
first calculation [=IF(F18>0,F18-TODAY(),"-")] and 4 representing th
the results of the first calculation divided by 7.

Any help would be huge!

Many thanks

 

[Ron Rosenfeld]

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(F18>0,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(F18>0,F18-TODAY(),"-") & " / " & IF(F18>0,ROUND((F18-TODAY())/7,1),"-")

 

[GS]

Ron Rosenfeld pretended :

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(F18>0,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(F18>0,F18-TODAY(),"-") & " / " & IF(F18>0,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

 

[Ron Rosenfeld]

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.

 

[GS]

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