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