+ Reply to Thread
Results 1 to 5 of 5

Have cell with formula show 0 till another cell shows a value.

Hybrid View

  1. 07-22-2019, 06:33 PM #1
    racer3
    racer3 is offline
    Registered User
    Join Date
    07-05-2019
    Location
    usa
    MS-Off Ver
    2016
    Posts
    29

    Have cell with formula show 0 till another cell shows a value.

    I need cell K54 to show 0 until a value is in cell K53. Then it should subtract the 7.77 from K3. Thanks.
    Attached Files Attached Files
    Last edited by racer3; 07-22-2019 at 06:36 PM.
    Reply With QuoteRegister To Reply
  2. 07-22-2019, 07:44 PM #2
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Have cell with formula show 0 till another cell shows a value.

    Try this...
    =IF(K53>0,K53-7.77,0)
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 07-22-2019, 07:44 PM #3
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,265

    Re: Have cell with formula show 0 till another cell shows a value.

    Hi racer3,

    Try this in K54

    Formula: copy to clipboard 
    =IF(K53=0,0,K53-7.77)
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  4. 07-23-2019, 07:07 AM #4
    racer3
    racer3 is offline
    Registered User
    Join Date
    07-05-2019
    Location
    usa
    MS-Off Ver
    2016
    Posts
    29

    Re: Have cell with formula show 0 till another cell shows a value.

    Thanks guys, both worked.
    Reply With QuoteRegister To Reply
  5. 07-23-2019, 07:10 AM #5
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Have cell with formula show 0 till another cell shows a value.

    You're welcome! Glad we could help.
    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. Formula to look in adjacent cell, then look upwards till a nonblank cell is found
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-23-2016, 06:27 AM
  2. [SOLVED] Formula shows as text in cell entered and result shows in another cell
    By r.coon in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-16-2015, 11:57 PM
  3. [SOLVED] IF Function when formula copy to another cell, shows #value , would like to show 0
    By Bitto in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-04-2013, 11:11 AM
  4. [SOLVED] Formula for a cell value to show as blank till the varible has been entered
    By arkadd61 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-27-2013, 09:46 PM
  5. [SOLVED] Excel formula builder shows the right value but doesn't show in cell
    By cheung in forum Excel General
    Replies: 3
    Last Post: 04-24-2012, 02:06 PM
  6. cell shows 20. Formula shows 20. why not 540/27
    By William Horton in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 02:05 PM
  7. cell shows 20. Formula shows 20. why not 540/27
    By William Horton in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04: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