Formula
If I want the total profit column to increase to reflect when the items sold column increases, How would I write the formula. I am very new to this thank you.
Answers

Hi @Ash2024
I am not sure if you intend to use just one row and keep changing the items sold value. If you're, your Total Profit Column could be a simple formula of =[Items Sold column]@row x [Total Cost column].
Thanks,
Aravind
Reach out for any help on licenses, configuration, or training

Can you provide a screen shot or more context?

I would like to write a formula so that if the number of items sold goes up it would automatically reflect accurately in the total profit column.

You would enter this in the Total Item Profit Column:
 =[My royalty/ profit]@row * [Total number item sold]@row
Hope this helps!
Best,
Zach Hall
Training Delivery Manager / Charter Communications
Help Article Resources
Categories
Check out the Formula Handbook template!