Solved

ActiveCell.Formula = "=IF(ISERROR(1-F3/E3);0;(1-F3/E3))" WHAT IS WRONG

Posted on 2011-02-22
8
495 Views
Last Modified: 2012-05-11
Dear experts,

Excel VBA will not exept   ActiveCell.Formula = "=IF(ISERROR(1-F3/E3,0,(1-F3/E3))" for a selected cell. I get runtime error 1004

Does anyobe have an idea why and how to solve it?


Kind regards

Eric
0
Comment
Question by:Eric Zwiekhorst
8 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 34950297
Hello,

you're not closing the brackets in the right place

=IF(ISERROR(1-F3/E3),0,(1-F3/E3))

cheers, teylyn
0
 
LVL 24

Expert Comment

by:jimyX
ID: 34950319
You forgot "("
ActiveCell.Formula = "=IF(ISERROR(1-F3/E3),0,(1-F3/E3))"
0
 
LVL 6

Author Comment

by:Eric Zwiekhorst
ID: 34950324
He teylin, I do not understand what you mean with brackets?

is )     or is it "
this was my formula

"=IF(ISERROR(1-F3/E3,0,(1-F3/E3))"
this is yours?
 =IF(ISERROR(1-F3/E3),0,(1-F3/E3))

Where is the difference?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 34950332
These are brackets ()

these are double quotes ""

the formula in your post is

=IF(ISERROR(1-F3/E3,0,(1-F3/E3))  -- you are not closing the IsError correctly
=IF(ISERROR(1-F3/E3),0,(1-F3/E3))

It's the missing closing bracket after the first E3.

cheers, teylyn
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 34950378
Can you please explain why you ignored my suggestion, which put the missing bracket in exactly the same place, giving an explanation about it, and all that 4 minutes before the answer you accepted?
0
 
LVL 24

Expert Comment

by:jimyX
ID: 34950411
Zwiekhorst,
The answer was provided by Teylyn first.
0
 
LVL 1

Expert Comment

by:Vee_Mod
ID: 34990693
All,
 
Following a request by teylyn (at http://www.experts-exchange.com/Q_26838365.html) to the closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Experts.
 
At this point I am going to re-start the auto-close procedure.
 
Thank you,
 
Vee_Mod
Community Support Moderator
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now