How can write this as workbook function ???

[pls123]

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

 

[Ryan H]

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

 

[pls123]

tx ryan !!
it was exactly this..

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

happy weekend !
paolo

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

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

 

[pls123]

exactly...

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

paolo

tx ryan !!
it was exactly this..

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

happy weekend !
paolo

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

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