+ Reply to Thread
Results 1 to 4 of 4

If Then Statement help

  1. 10-21-2013, 08:26 AM #1
    LAW99 is offline
    Registered User
    Join Date
    10-21-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2013
    Posts
    4

    If Then Statement help

    I keep getting an error message for this function:

    Function Gear(RPM As Double, Gear1 As Double)
    Please Login or Register  to view this content.
    I'm not sure what's wrong with the function. Error says Block End If.
    Last edited by Fotis1991; 10-21-2013 at 08:28 AM. Reason: Pls use code tags around your code.
    Reply With QuoteRegister To Reply
  2. 10-21-2013, 08:30 AM #2
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: If Then Statement help 

    Please Login or Register  to view this content.
    Last edited by AB33; 10-21-2013 at 08:34 AM.
    Reply With QuoteRegister To Reply
  3. 10-21-2013, 08:56 AM #3
    LAW99 is offline
    Registered User
    Join Date
    10-21-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: If Then Statement help

    Thanks, I tried that. Now I just get a zero value for the function. I'm not sure if I defined the inputs wrong or what. RPM is between 3000 and 7200. Gear1 is between 1.45 and 3.20.
    Reply With QuoteRegister To Reply
  4. 10-21-2013, 09:20 AM #4
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: If Then Statement help

    You are probably getting this line

    Gear = Gear1
    Since your gear starts at 1, the else may return 0.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Compile Error : line number or label or statement or end of statement
    By excellearner121 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2013, 06:41 PM
  2. [SOLVED] Convert If statement with cell row reference calculations to vlookup statement
    By excyclist in forum Excel General
    Replies: 4
    Last Post: 06-01-2012, 10:05 AM
  3. VBA- Compile Error, Expected: line number or label or statement or end of statement
    By RLK7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2012, 05:33 PM
  4. Have question about using .find statement and brackets around After:= statement
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-09-2011, 03:28 PM
  5. [SOLVED] Utilize a Select Case Statement in Target Intersect Statement
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2009, 08:55 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1