Forum Discussion
SnowMan55
Bronze Contributor
KEVance318 That makes some sense, but some things are not clear.
- Are you using an Excel table, or by "table" do you mean a range of rows and columns? I have to ask as the syntax you showed for your Net calculation is not valid.
- Does a row represent an individual sale, or an accumulation of sales (e.g., by week or month or other time period)?
- Do you have a column that contains the relevant year or date?
- Are you permitted to add columns? It seems that you should have a Commission column, and the 10% or 13% value should go there (only), where rounding can be handled properly, to satisfy the bean counters.
KEVance318
Nov 06, 2022Copper Contributor
I appreciate you taking the time to clarify; I will do my best, but I actually googled what a table is, and the internet responses made me laugh out loud! I am permitted to add whatever I want, because I am the only one tracking this info; I am the sole bean counter, although there are many other folks who appreciate me trying to get this right. Google searches helped me write all of the formulas. I'm not sure about the syntax; I was just happy that the formulas were doing what they were supposed t do (I did check manually). Here is how this came about: I simply opened a new "workbook" in Excel. Every row represents a product that we sell. Each column is info we track: number of items purchased, number of items in inventory, cost of each individual item, sales price, number sold (which has a formula to update as the numbers in inventory decrease), sales to date in dollars (which has a formula to subtract cost of sold item from sales price), sales in dollars minus 10% commission. So, if I change the 10% to 13% for the items sold, it will change the net historically, when I want to keep 10% up until December 2022. So, I am assuming that you can write an "if before this date, then this happens," "if after this date, this happens" type of formula. My Google searches have let me down here. I am sure not knowing the terminology was part of the problem. Did I mention I was an English/Theatre Arts/Counseling major? Thank you for your help. P. S. Please explain the purpose of a column for relevant year or date. We don't actually have a fiscal year for this endeavor. Should I make that happen?