How can write this as workbook function ???

's Computer Specifications

How can write this as workbook function ???

Workbooks("@@@@PLT@@@@MI.UCG.xlsm").Sheets("Sheet1").Range("D" &
aWS.Range("A16").Value & "").Value

it would be something like this
='[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$ ^^^thisworkbook.A16.value^^^

and how would it be inside an IF function , requiring that value = zero (for
example!)

tx if can help me about
paolo

's Computer Specifications

I think this is what you are wanting. Hope this helps! If so, let me know,
click "YES" below.

=IF("[("@@@@PLT@@@@MI.UCG]Sheet1!$D$"&A16="0","True", "False")

--
Cheers,
Ryan

"pls123" wrote:

> How can write this as workbook function ???
>
> Workbooks("@@@@PLT@@@@MI.UCG.xlsm").Sheets("Sheet1").Range("D" &
> aWS.Range("A16").Value & "").Value
>
> it would be something like this
> ='[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$ ^^^thisworkbook.A16.value^^^
>
> and how would it be inside an IF function , requiring that value = zero (for
> example!)
>
> tx if can help me about
> paolo

's Computer Specifications

tx ryan !!
it was exactly this..

=AND("[(@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$"&A16>=A20)

happy weekend !
paolo

"Ryan H" wrote:

> I think this is what you are wanting. Hope this helps! If so, let me know,
> click "YES" below.
>
> =IF("[("@@@@PLT@@@@MI.UCG]Sheet1!$D$"&A16="0","True", "False")
>
> --
> Cheers,
> Ryan
>
>
> "pls123" wrote:
>
> > How can write this as workbook function ???
> >
> > Workbooks("@@@@PLT@@@@MI.UCG.xlsm").Sheets("Sheet1").Range("D" &
> > aWS.Range("A16").Value & "").Value
> >
> > it would be something like this
> > ='[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$ ^^^thisworkbook.A16.value^^^
> >
> > and how would it be inside an IF function , requiring that value = zero (for
> > example!)
> >
> > tx if can help me about
> > paolo

's Computer Specifications

exactly...

cant find the real syntax with parenthesis and other...
i will make some try tx !!

paolo

"pls123" wrote:

> tx ryan !!
> it was exactly this..
>
> =AND("[(@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$"&A16>=A20)
>
> happy weekend !
> paolo
>
>
> "Ryan H" wrote:
>
> > I think this is what you are wanting. Hope this helps! If so, let me know,
> > click "YES" below.
> >
> > =IF("[("@@@@PLT@@@@MI.UCG]Sheet1!$D$"&A16="0","True", "False")
> >
> > --
> > Cheers,
> > Ryan
> >
> >
> > "pls123" wrote:
> >
> > > How can write this as workbook function ???
> > >
> > > Workbooks("@@@@PLT@@@@MI.UCG.xlsm").Sheets("Sheet1").Range("D" &
> > > aWS.Range("A16").Value & "").Value
> > >
> > > it would be something like this
> > > ='[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$ ^^^thisworkbook.A16.value^^^
> > >
> > > and how would it be inside an IF function , requiring that value = zero (for
> > > example!)
> > >
> > > tx if can help me about
> > > paolo

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do you write format results of a function within a function?	=?Utf-8?B?c2FuZ2Vl?=	Microsoft Excel Worksheet Functions	3	14th Jun 2007 12:45 AM
Sum data in workbook 1 and write result in workbook 2	Martin	Microsoft Excel Discussion	1	7th May 2006 02:48 PM
Sum data in workbook 1 and write result in workbook 2	Martin	Microsoft Excel Programming	1	7th May 2006 02:48 PM
how do I write a vlookup function within an iserror function so t.	=?Utf-8?B?SkJMZWVkcw==?=	Microsoft Excel Worksheet Functions	2	16th Mar 2005 10:30 AM
Call function from one workbook that resides in another workbook m	=?Utf-8?B?RGF0YXNvcnQ=?=	Microsoft Excel Programming	3	16th Jan 2005 10:33 PM