Solved

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

Posted on 2011-02-22
8
497 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
Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

831 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