Edit percentage calc column to price.

[krsone]

Hi all! Totally noob alert here. I am not familiar with excel at all. But would appreciate some help changing a calculation in a column of a template I got from MS.
So the template is this one https://templates.office.com/en-us/O...ker-TM10000095
I really like it, because it's simple and looks good. I would however like to change the "Percet markup" calculation and make it a direct "sold for". Since I have different buyers paying different prices on the same product.
So I would rather like to change it to: "Cost per item", "Item sold for".... And have Excel calculate it all for me. In order to not have to calculate the different percent markup on every sale I make.
Hope anyone can help me out changing that!
Thanks for now!

[CAntosh]

Change the heading to "Item Sold For" and adjust the formatting to the currency of your choice. Enter the appropriate amounts, then change the formula in F16 to:

=IFERROR([@[Total Sold]]*[@[Item Sold For]],0)

[CAntosh]

I16 becomes:

=IFERROR([@[Item Sold For]]+[@[Shipping Charge/Item]]-[@[Shipping Cost/Item]],0)

[krsone]

Thanks for you help Cantosh!
I formatted the percentage cell and changed it to currency. Also changed the heading to exactly what you wrote.
But I get an error when trying to change the formula in F16. "The name that you've entered is not valid"
And even though I changed D16 from % to currency. I still get the percent margin.
Cost per item: 10, Item sold for: 20, Total sold: 1, and get Total revenue of 210..

Lol I must be doing something wrong, so please bare with me

[CAntosh]

Take a look at the attachment, see if it helps. In the attachment, I also changed the formula for I16:I20. Forum user JeteMc helpfully pointed out that I neglected to account for the item cost in the formula I gave you in post #3. For some reason I interpreted "Item Cost" as MSRP, whereas the other formulas in the table indicate that it should be regarded as an actual cost. The new formula for I16:I20 is:

=IFERROR([@[Item Sold For]]-[@[Cost Per Item]]+[@[Shipping Charge/Item]]-[@[Shipping Cost/Item]],0)

[krsone]

Awesome! You pretty much did the work for me. But will take this useful information in account for further modifications.
Thank you so very much Cantosh!! Very helpful!!

[CAntosh]

Glad to help, good luck!