+ Reply to Thread
Results 1 to 5 of 5

Keeping a cell blank if the related cells shows

  1. 12-24-2014, 05:17 AM #1
    Anuru
    Anuru is offline
    Forum Contributor
    Join Date
    12-06-2013
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2016
    Posts
    613

    Keeping a cell blank if the related cells shows

    Hi experts,

    Pls refer to the attached excel document. There I need the cell P16 to be blank if the the cell P13 has "0" or "blank". Pls note that it (P16) already contains a formula as per my basic requirement, however I need this new requirement also to be merged with that.

    B/regards
    Anuruddha
    Reply With QuoteRegister To Reply
  2. 12-24-2014, 05:18 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Keeping a cell blank if the related cells shows

    Attachment is missing


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 12-24-2014, 05:22 AM #3
    Anuru
    Anuru is offline
    Forum Contributor
    Join Date
    12-06-2013
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2016
    Posts
    613

    Re: Keeping a cell blank if the related cells shows

    Pls...Sorry....
    Just added...
    Reply With QuoteRegister To Reply
  4. 12-24-2014, 05:26 AM #4
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Keeping a cell blank if the related cells shows

    Quote Originally Posted by Anuru View Post
    Just added...
    Still unable to find it
    Reply With QuoteRegister To Reply
  5. 12-24-2014, 05:27 AM #5
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Keeping a cell blank if the related cells shows

    It seems that you have started another thread (in the below link) for adding the Attachment.

    http://www.excelforum.com/excel-form...-or-blank.html
    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] Autofilter by blank cells in one column and also shows row above it
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2014, 08:55 PM
  2. [SOLVED] Auto Fill from other columns and using IF with related to blank or Zero cells
    By Psionicrnd in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-05-2014, 05:45 AM
  3. [SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell
    By nunayobinezz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2013, 04:51 PM
  4. [SOLVED] Need Help Keeping Cells Blank Until Data is placed in Input Cell
    By areidel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-19-2012, 05:45 PM
  5. Delete cells that contain a function that shows up blank
    By ISARTC3 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2005, 02:16 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