• When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.

Archived

This topic is now archived and is closed to further replies.

Help EXCEL SPREADSHEET

Started by ultimatevenom,

2 posts in this topic

ultimatevenom

ultimatevenom

Posted
Posted

Ok

 

I am doing an Excel Spreadsheet for Detective Comics 1-26 ( Includes all grades eg 9.8 etc.)

 

And i cannot figure out a formula for 9.6 and above

 

I remember someone posted one with all of the prices for Archies or Pep Comics, but i cannot find it

 

Thanks

 

Venom

Link to comment
Share on other sites
sfilosa

sfilosa

Posted
Posted

Use and IF Statement.

 

Example =IF(A5=9.6,A20*1.5,0)

 

A5 is the grading sell (ie. 9.0,9.2, etc.) and A20 is the price of a 9.4. In this case I am implying that a 9.6 would sell for a 50% premium over the 9.4 price (that's just for example).

 

 

 

Link to comment
Share on other sites
Go to topic listing