Formula error

[ineedhelp2]

The formula below receives an error in my macro. Can someone pleas
help me edit it to work?


Code
-------------------

Range("A6").Select
ActiveCell.FormulaR1C1 = _
"=IF(ISBLANK(RC[4])=TRUE,"""",(IF(OR(RC[1]=Summary!R7C1,RC[1]=Summary!R8C1,RC[1]=Summary!R9C1,RC[1]=Summary!R11C1,RC[1],RC[1]=Summary!R12C1=Summary!R7C1,RC[1]=Summary!R13C1,RC[1]=Summary!R15C1,RC[1]=Summary!R7C1,RC[1]=Summary!R16C1)=TRUE,'Raw Data'!R[-1]C[10],"""")"
Range("A6").Select

 

[Tom Ogilvy]

You have your formula jumbled up right here:

,RC[1],RC[1]=Summary!R12C1=Summary!R7C1,RC[1]=Summary!R13C1

--
Regards,
Tom Ogilvy

The formula below receives an error in my macro. Can someone please
help me edit it to work?


Code:

"=IF(ISBLANK(RC[4])=TRUE,"""",(IF(OR(RC[1]=Summary!R7C1,RC[1]=Summary!R8C1,R
C[1]=Summary!R9C1,RC[1]=Summary!R11C1,RC[1],RC[1]=Summary!R12C1=Summary!R7C1
,RC[1]=Summary!R13C1,RC[1]=Summary!R15C1,RC[1]=Summary!R7C1,RC[1]=Summary!R1
6C1)=TRUE,'Raw Data'!R[-1]C[10],"""")"

 

[Tom Ogilvy]

You also need to add two parens on the end (a total of 3 parens)

'Raw Data'!R[-1]C[10],"""")"

should be

'Raw Data'!R[-1]C[10],"""")))"

That would make it complete, but you don't then have an defined response if
the first IF is false.

--
Regards,
Tom Ogilvy

The formula below receives an error in my macro. Can someone please
help me edit it to work?


Code:

"=IF(ISBLANK(RC[4])=TRUE,"""",(IF(OR(RC[1]=Summary!R7C1,RC[1]=Summary!R8C1,R
C[1]=Summary!R9C1,RC[1]=Summary!R11C1,RC[1],RC[1]=Summary!R12C1=Summary!R7C1
,RC[1]=Summary!R13C1,RC[1]=Summary!R15C1,RC[1]=Summary!R7C1,RC[1]=Summary!R1
6C1)=TRUE,'Raw Data'!R[-1]C[10],"""")"