+ Reply to Thread
Results 1 to 5 of 5

IF to verify that cell 1 is greater than zero and cell 2 is equal to the exact text, and t

  1. 03-11-2013, 03:38 PM #1
    NTK_NKGK
    NTK_NKGK is offline
    Registered User
    Join Date
    03-11-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    4

    IF to verify that cell 1 is greater than zero and cell 2 is equal to the exact text, and t

    Hi
    I sit with this code.
    Everything works except the red highlighted line.
    What I want is to use the IF to verify that cell 1 is greater than zero and cell 2 is equal to the exact text, and then write "" my text "" to B45.

    thanks in advance


    Please Login or Register  to view this content.
    Moderators note: code tags added for you - this time
    Last edited by FDibbins; 03-11-2013 at 04:05 PM.
    Reply With QuoteRegister To Reply
  2. 03-11-2013, 03:47 PM #2
    Bob1980
    Bob1980 is offline
    Forum Contributor
    Join Date
    09-13-2011
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    111

    Re: IF to verify that cell 1 is greater than zero and cell 2 is equal to the exact text, a

    try

    Please Login or Register  to view this content.
    also, please use code tags 
    Please Login or Register  to view this content.
    , it's the number sign on top of the area that you write your posts into.

    1980
    Reply With QuoteRegister To Reply
  3. 03-11-2013, 04:02 PM #3
    NTK_NKGK
    NTK_NKGK is offline
    Registered User
    Join Date
    03-11-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: IF to verify that cell 1 is greater than zero and cell 2 is equal to the exact text, a

    Thanks for the quick reply Bob.
    but I've tried it, but get syntax error
    thanks in advance

    Please Login or Register  to view this content.
    Skärmklipp.JPG
    Reply With QuoteRegister To Reply
  4. 03-11-2013, 05:00 PM #4
    NTK_NKGK
    NTK_NKGK is offline
    Registered User
    Join Date
    03-11-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: IF to verify that cell 1 is greater than zero and cell 2 is equal to the exact text, a

    Thanks Mod, sorry about that
    Reply With QuoteRegister To Reply
  5. 03-12-2013, 05:40 PM #5
    NTK_NKGK
    NTK_NKGK is offline
    Registered User
    Join Date
    03-11-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: IF to verify that cell 1 is greater than zero and cell 2 is equal to the exact text, a

    Has solved the problem Bob, quite equally, so little that makes it great.
    Thanks in any case.
    Here it comes

    Please Login or Register  to view this content.
    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)

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