+ Reply to Thread
Results 1 to 4 of 4

Change to a formula

  1. 04-13-2014, 10:41 PM #1
    mikerules
    mikerules is offline
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    221

    Change to a formula

    =IF(D8<>"",0.02,"")

    I am using the above formula to populate 2% when any entry is made to D8 however I would like it to exclude the number 9999 if that is the entry made to D8
    Reply With QuoteRegister To Reply
  2. 04-13-2014, 11:26 PM #2
    DarthVader68
    DarthVader68 is offline
    Registered User
    Join Date
    02-27-2014
    Location
    Range("A1")
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Change to a formula

    Use:
    Please Login or Register  to view this content.
    ZAX
    I'm glad you got it to work :-D
    ZAX
    Reply With QuoteRegister To Reply
  3. 04-14-2014, 09:46 AM #3
    mikerules
    mikerules is offline
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: Change to a formula

    Thank-you that works great
    Reply With QuoteRegister To Reply
  4. 04-18-2014, 04:44 AM #4
    DarthVader68
    DarthVader68 is offline
    Registered User
    Join Date
    02-27-2014
    Location
    Range("A1")
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Change to a formula

    Quote Originally Posted by mikerules View Post
    Thank-you that works great
    You're welcome, glad you got it to work =D
    ZAX
    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. Auto change formula to include Tab name change
    By jimmisavage in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-17-2013, 05:50 AM
  2. [SOLVED] Result of formula doesn't change when I change input (the value in a cell)
    By Motox in forum Excel General
    Replies: 2
    Last Post: 06-11-2012, 07:30 PM
  3. auto change cell formula on condition of worksheet change in other cells
    By futurejock in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-01-2009, 12:11 AM
  4. change cell value and not change formula
    By blck_transam in forum Excel General
    Replies: 10
    Last Post: 01-28-2007, 07:55 PM
  5. How does Data Validation change with a formula change?
    By MayClarkOriginals in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-04-2006, 11:55 PM

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