1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel Again

Discussion in 'Microsoft Office Specialist (MOS)' started by Nelix, Nov 17, 2003.

  1. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,412
    3
    82
    OK, i'm creating a spreadsheet to keep records of items sold on an auction and 3 of my columns are as follows

    Cost, Postage, Total,

    Now I have put formulas in the total column to calculate the cost + postage but here's where it gets tricky.

    The cost is unknown until the auction ends so even though i have put the postage in, i dont want the total column to be populated with just the postage until i enter the cost at the end of the auction.

    Is this possible????

    Hope that makes sense, if not i'm sure you will let me know. :D
     
    Certifications: A+, 70-210, 70-290, 70-291
    WIP: 70-294
  2. Phil
    Honorary Member

    Phil Gigabyte Poster

    1,680
    7
    87
    Derek, you could try putting the following formula in your total column

    =IF(A2>0,A2+B2,"Not Sold")

    Column A = Cost
    Column B = Postage
    Column C = Total

    It checks if The cost column has a value, if it does it adds up the cost and postage and if not Places "Not Sold" in the total column.

    Is that what you need?
     
    Certifications: MCSE:M & S MCSA:M CCNA CNA
    WIP: 2003 Upgrade, CCNA Upgrade
  3. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,412
    3
    82
    thats the one phil.......you're a genious :super
     
    Certifications: A+, 70-210, 70-290, 70-291
    WIP: 70-294
  4. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,412
    3
    82
    Hi Phil, just another quick question,

    I have made all the cells within the above columns 'Currency' will i still be able to use the formula that you posted above as it will populate the total cells with text.
     
    Certifications: A+, 70-210, 70-290, 70-291
    WIP: 70-294
  5. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,412
    3
    82
    Sorted, just created a test doc here at work and it works fine.

    Thanks again
     
    Certifications: A+, 70-210, 70-290, 70-291
    WIP: 70-294

Share This Page

Loading...