Excel Again

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

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.

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

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?

 

thats the one phil.......you're a genious

 

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.

 

Sorted, just created a test doc here at work and it works fine.

Thanks again