+ Reply to Thread
Results 1 to 4 of 4

Adding a default entry or "-" in a cell, based on another column being empty.

  1. #1
    Registered User
    Join Date
    01-31-2008
    Posts
    19

    Adding a default entry or "-" in a cell, based on another column being empty.

    I'm trying to create a costings table where you can specifiy the poduct code (thus price per metre), it's length and a range of other variables which affect the price.

    Some of the products we sell need to have a length specified per piece, others are just parts you need to specify a quantity of.

    My basic table is as follows (cell numbers shown):

    A B
    11 Qty. Length
    12
    13
    14

    What I'm wanting to achieve is:

    If 'Qty'. is blank, then 'Length' is blank by default
    If 'Qty.' shows a number then 'Length' shows '-' by default

    '-' should be able to be manually over-ridden with a typed in number.

    Can anyone point me in the right direction?

    =IF(A12="",B12=""), IF(A12="??????",B12="-")

    I'm pretty new to excel functions so am I on the right track, what should ????? be in the equation above.

    Many thanks in advance for any help!

  2. #2
    Registered User
    Join Date
    01-17-2008
    Posts
    28
    Try this

    =IF(A12="","","-")
    Put that in b12 cell. Not sure if this is what you mean or not. If not let me know.
    Last edited by johnnybs; 01-31-2008 at 12:45 PM.

  3. #3
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    =if(a12>0,"-","")
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  4. #4
    Registered User
    Join Date
    01-31-2008
    Posts
    19
    Both work thanks guys. Always numerous ways to get the same result, thanks for the speedy replies.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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