error in code

Please Login or Register  to view this content.

In the above code , i am facing error.. in converting the formula?? can anyone correct it?

reference formula in the cell which this code is trying to convert is
=IF(SUM(X38:X39)<>0,0,IF('account_type_transactions (2)'!P585=0,SUM('account_type_transactions (2)'!P585:P586),IF('account_type_transactions (2)'!P585=1,SUM('account_type_transactions (2)'!R585:R586),IF('account_type_transactions (2)'!P585>2000,SUM('account_type_transactions (2)'!R591:R592)))))

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: link to be added here

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.