+ Reply to Thread
Results 1 to 4 of 4

Cell to display 0 if the value is greater than 10

  1. 05-19-2016, 09:40 AM #1
    CPAC
    CPAC is offline
    Forum Contributor
    Join Date
    05-14-2015
    Location
    West Yorkshire
    MS-Off Ver
    10
    Posts
    130

    Cell to display 0 if the value is greater than 10

    Hi,

    I need to get cell D5 to show 0 if the value is greater than 10. Is this possible?

    Thanks,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-19-2016, 09:51 AM #2
    peterrc
    peterrc is offline
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Cell to display 0 if the value is greater than 10

    Hi,

    Yes it is.

    Change your formula in D5 to:-

    =IF(1210/D4>10,"0", 1210/D4)

    peterrc
    Reply With QuoteRegister To Reply
  3. 05-19-2016, 09:53 AM #3
    shirleyxls
    shirleyxls is offline
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Cell to display 0 if the value is greater than 10

    Try:

    =IF(1210/D4>10,0,1210/D4)

    in D5
    Reply With QuoteRegister To Reply
  4. 05-19-2016, 09:57 AM #4
    CPAC
    CPAC is offline
    Forum Contributor
    Join Date
    05-14-2015
    Location
    West Yorkshire
    MS-Off Ver
    10
    Posts
    130

    Re: Cell to display 0 if the value is greater than 10

    Perfect. Thank you guys....
    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. [SOLVED] Display a row if a cell value is greater than zero
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 07:05 PM
  2. Display a row if a cell value is greater than zero
    By vmerrill in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  3. [SOLVED] Display a row if a cell value is greater than zero
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 02:05 PM
  4. [SOLVED] Display a row if a cell value is greater than zero
    By vmerrill in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] Display a row if a cell value is greater than zero
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  6. Display a row if a cell value is greater than zero
    By vmerrill in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] Display a row if a cell value is greater than zero
    By vmerrill in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  8. [SOLVED] Display a row if a cell value is greater than zero
    By vmerrill in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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