+ Reply to Thread
Results 1 to 3 of 3

Only show data in one column if there is data in another

  1. #1
    Registered User
    Join Date
    03-16-2020
    Location
    Manchester, England
    MS-Off Ver
    Microsoft Office 365
    Posts
    2

    Only show data in one column if there is data in another

    Hello,

    I'm not an expert Excel user, so am struggling with a sum. Any help would be much appreciated!

    Basically, I want the user to only have to enter data in column E (In Stock) - when they fill this in, the spreadsheet will work out how many items to order in column F { =MAX(0,C2-E2) }. The spreadsheet will then also work out the order values in column G { =F2*B2 }.

    However, if column E is left blank I don't want any values to show in either F or G, as it is currently displaying the maximum values in each. Does anybody know the formula that would solve this issue?

    Many thanks!
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-26-2020
    Location
    US
    MS-Off Ver
    2010
    Posts
    157

    Re: Only show data in one column if there is data in another

    Try in F2 and drag down:

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


    In G2 and drag down:

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

  3. #3
    Registered User
    Join Date
    03-16-2020
    Location
    Manchester, England
    MS-Off Ver
    Microsoft Office 365
    Posts
    2

    Re: Only show data in one column if there is data in another

    Thanks so much, this has solved it.

    Much appreciated!

+ 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] How to show the column that data first appear
    By tuanvu in forum Excel General
    Replies: 4
    Last Post: 11-03-2018, 12:16 PM
  2. Replies: 2
    Last Post: 10-28-2015, 12:43 AM
  3. [SOLVED] Function to get data from a column and show it in a row
    By kgw in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-02-2015, 08:23 AM
  4. [SOLVED] only show data if other column has a figure, otherwise show zero.
    By jitterbug888 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-05-2015, 11:28 PM
  5. Display all rows of data which show specific data in specified column
    By muaddib87 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-02-2012, 01:33 PM
  6. Replies: 1
    Last Post: 02-09-2010, 06:16 PM
  7. [SOLVED] Matching one column against another column of data to show the same amount of data.
    By dodat in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-30-2005, 02:20 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