+ Reply to Thread
Results 1 to 4 of 4

excel 2010 empty a cell according to other cells (without Deleting them just show empty)

  1. 02-11-2015, 01:20 PM #1
    pavlos_x
    pavlos_x is offline
    Registered User
    Join Date
    02-10-2015
    Location
    cyprus
    MS-Off Ver
    2010
    Posts
    50

    excel 2010 empty a cell according to other cells (without Deleting them just show empty)

    according to the picture i have a result from another sheet (in red)
    can i empty that cell according to other cells cell C97 (without Deleting them just show empty)
    Cell C97 already has a formula though =MDB_MEL!Q36

    1111.jpg
    Reply With QuoteRegister To Reply
  2. 02-11-2015, 01:37 PM #2
    daffodil11
    daffodil11 is offline
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: excel 2010 empty a cell according to other cells (without Deleting them just show empt 

    Please Login or Register  to view this content.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!
    Reply With QuoteRegister To Reply
  3. 02-11-2015, 01:38 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,082

    Re: excel 2010 empty a cell according to other cells (without Deleting them just show empt

    Formula: copy to clipboard 
    Please Login or Register  to view this content.



    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 02-11-2015, 01:46 PM #4
    pavlos_x
    pavlos_x is offline
    Registered User
    Join Date
    02-10-2015
    Location
    cyprus
    MS-Off Ver
    2010
    Posts
    50

    Re: excel 2010 empty a cell according to other cells (without Deleting them just show empt

    it doesn't work because i forgot to mention that actually C97 has a formula but result is 0 (is taking ='MAIN DB'!B23)
    when i use your formula =IF(C97="","",MDB_MEL!Q36) i put 0 in the "" but still nothing

    thanks for the quick respond
    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. Filling Empty cell value based on if else condition and delete row more than 2 cells empty
    By maheshkanda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2014, 01:31 PM
  2. Find empty cell in column, and apply required character to empty visable cells.
    By Chris Acheson in forum Excel General
    Replies: 5
    Last Post: 05-13-2014, 10:19 AM
  3. Need to find empty filled cells in a column and copy to the empty cell below
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2014, 10:09 AM
  4. Deleting empty rows if specific cell in row is empty
    By csynic in forum Excel General
    Replies: 0
    Last Post: 07-06-2011, 01:43 AM
  5. Excel 2000 Deleting Empty Cells
    By Fleeman in forum Excel General
    Replies: 3
    Last Post: 05-13-2008, 01:54 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