Prev: Find and Replace only the first character
Next: Look up, return value
From: Wildwood on 31 Mar 2010 09:34
I'm hoping someone on here can assist me....Both of these formulas are
returning #Name errors.......Please suggest alternative formulas....


Formula #1:
"ALL QUOTED LEASE FACTORS EXPIRE ON "&TEXT(EOMONTH(NOW(),0),"MMM-DD-YYYY")&"
AND ARE SUBJECT TO VERIFICATION PRIOR TO FUNDING"

Formula #2:
"QUOTED ASSUMPTIONS ARE VALID FROM "&TEXT(TODAY(),"MMM-DD-YYYY")&" -
"&TEXT(EOMONTH(NOW(),0),"MMM-DD-YYYY")&". LEASES MUST BE CASHED BEFORE
"&TEXT(EOMONTH(NOW(),1), "MMM-DD-YYYY")
From: Luke M on 31 Mar 2010 09:40
Make sure the Analysis ToolPak add-in is installed.

--
Best Regards,

Luke M
"Wildwood" <Wildwood(a)discussions.microsoft.com> wrote in message
news:6E3CD25D-72EC-4A1C-A27E-A19FAFD9C48D(a)microsoft.com...
> I'm hoping someone on here can assist me....Both of these formulas are
> returning #Name errors.......Please suggest alternative formulas....
>
>
> Formula #1:
> "ALL QUOTED LEASE FACTORS EXPIRE ON
> "&TEXT(EOMONTH(NOW(),0),"MMM-DD-YYYY")&"
> AND ARE SUBJECT TO VERIFICATION PRIOR TO FUNDING"
>
> Formula #2:
> "QUOTED ASSUMPTIONS ARE VALID FROM "&TEXT(TODAY(),"MMM-DD-YYYY")&" -
> "&TEXT(EOMONTH(NOW(),0),"MMM-DD-YYYY")&". LEASES MUST BE CASHED BEFORE
> "&TEXT(EOMONTH(NOW(),1), "MMM-DD-YYYY")


From: Mike H on 31 Mar 2010 09:43
Hi,

The formula are OK but you need to load the analysis toolpak.

Tools - Addins - Check 'analysis toolpak' OK

Select each formula cell tap F2 and enter
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Wildwood" wrote:

> I'm hoping someone on here can assist me....Both of these formulas are
> returning #Name errors.......Please suggest alternative formulas....
>
>
> Formula #1:
> "ALL QUOTED LEASE FACTORS EXPIRE ON "&TEXT(EOMONTH(NOW(),0),"MMM-DD-YYYY")&"
> AND ARE SUBJECT TO VERIFICATION PRIOR TO FUNDING"
>
> Formula #2:
> "QUOTED ASSUMPTIONS ARE VALID FROM "&TEXT(TODAY(),"MMM-DD-YYYY")&" -
> "&TEXT(EOMONTH(NOW(),0),"MMM-DD-YYYY")&". LEASES MUST BE CASHED BEFORE
> "&TEXT(EOMONTH(NOW(),1), "MMM-DD-YYYY")
From: Wildwood on 31 Mar 2010 09:47
Awesome...That worked!!! Many, many thanks!

"Mike H" wrote:

> Hi,
>
> The formula are OK but you need to load the analysis toolpak.
>
> Tools - Addins - Check 'analysis toolpak' OK
>
> Select each formula cell tap F2 and enter
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "Wildwood" wrote:
>
> > I'm hoping someone on here can assist me....Both of these formulas are
> > returning #Name errors.......Please suggest alternative formulas....
> >
> >
> > Formula #1:
> > "ALL QUOTED LEASE FACTORS EXPIRE ON "&TEXT(EOMONTH(NOW(),0),"MMM-DD-YYYY")&"
> > AND ARE SUBJECT TO VERIFICATION PRIOR TO FUNDING"
> >
> > Formula #2:
> > "QUOTED ASSUMPTIONS ARE VALID FROM "&TEXT(TODAY(),"MMM-DD-YYYY")&" -
> > "&TEXT(EOMONTH(NOW(),0),"MMM-DD-YYYY")&". LEASES MUST BE CASHED BEFORE
> > "&TEXT(EOMONTH(NOW(),1), "MMM-DD-YYYY")
 | 
Pages: 1
Prev: Find and Replace only the first character
Next: Look up, return value