+ Reply to Thread
Results 1 to 5 of 5

how to make formulas colums empty when data is not inserted onto it?

  1. #1
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    139

    how to make formulas colums empty when data is not inserted onto it?

    hi, i had a problem.i want colum(c7) emptied automatically when data in colum(b7) is not inserted onto it.please help.the data is in I sheet.thank you.the file is in the zip.
    Attached Files Attached Files
    Last edited by pejoi; 11-05-2019 at 10:16 PM.

  2. #2
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    139

    Re: how to make formulas colums empty when data is not inserted onto it?

    please help..for the sake of my pupils.thanks.

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: how to make formulas colums empty when data is not inserted onto it?

    in your file n number of sheet. in which sheet problem? Kindly mentioned details with desire output.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    139

    Re: how to make formulas colums empty when data is not inserted onto it?

    a,b,c,d,e,f,j,h,i and j sheet.(c7)
    Last edited by pejoi; 11-06-2019 at 02:50 AM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,734

    Re: how to make formulas colums empty when data is not inserted onto it?

    Quote Originally Posted by pejoi View Post
    please help..for the sake of my pupils.thanks.
    Administrative Note:

    We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it was only ten minutes between posts! Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Automatically insert row below once empty cells have value inserted
    By STUARTXL in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-24-2015, 02:27 PM
  2. Replies: 0
    Last Post: 06-30-2015, 06:42 PM
  3. Replies: 6
    Last Post: 08-29-2014, 08:31 AM
  4. How to make label value empty after display data
    By Dean Zuki in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-13-2014, 05:06 AM
  5. [SOLVED] How do i link formulas to total data from 2 colums with differing subjects.
    By meckenzie2012 in forum Excel General
    Replies: 4
    Last Post: 12-02-2012, 12:27 PM
  6. Replies: 2
    Last Post: 05-04-2012, 10:02 AM
  7. [SOLVED] Make two colums from one column of data
    By sek0910 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2006, 06:35 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1