How can write this as workbook function ???

  • Thread starter Thread starter pls123
  • Start date Start date
P

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
 
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")
 
tx ryan !!
it was exactly this..

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

happy weekend !
paolo


Ryan H said:
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 said:
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
Click to expand...
Click to expand...
 
exactly...

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

paolo





pls123 said:
tx ryan !!
it was exactly this..

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

happy weekend !
paolo


Ryan H said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top