Formula error
 

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

-------------------

--
ineedhelp
-----------------------------------------------------------------------
ineedhelp2's Profile: http://www.excelforum.com/member.php...fo&userid=2629
View this thread: http://www.excelforum.com/showthread.php?threadid=46884

Formula error
 

You have your formula jumbled up right he

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

--
Regards,
Tom Ogilvy



"ineedhelp2" wrote
in message ...

The formula below receives an error in my macro. Can someone please
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,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],"""")"
Range("A6").Select

--------------------


--
ineedhelp2
------------------------------------------------------------------------
ineedhelp2's Profile:
http://www.excelforum.com/member.php...o&userid=26298
View this thread: http://www.excelforum.com/showthread...hreadid=468841

Formula error
 

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


"ineedhelp2" wrote
in message ...

The formula below receives an error in my macro. Can someone please
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,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],"""")"
Range("A6").Select

--------------------


--
ineedhelp2
------------------------------------------------------------------------
ineedhelp2's Profile:
http://www.excelforum.com/member.php...o&userid=26298
View this thread: http://www.excelforum.com/showthread...hreadid=468841