Solved

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

Posted on 2011-02-22
8
496 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 AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
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 demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

803 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