can you send an example?
that would be great
upload your file to one of those sites.
they give you link
then paste that link here
i dont see a drop down box, and formulas don't usually link to those anyway.
Lets assume that I don't know any terminology COGS for example.
Can you give me in Column M if that is where you want your number what the expected numbers would be if you did the math manually? And how you derive those numbers mathamaticlaly?
try if possible to refer to cells or numbers, are you taking numbers from column D for example?
so it varies based on that number?
well honestly at this point I would recomend a macro be used to calculate and populate the cells in M column. Basically the macro could be made to fire off everytime you change the value in that cell. I could probably devise a formula to do this, but it would be a very complicated formula.
There would be a slight additional charge to create a macro because it is a bit complicated, but I think it can be done.
total cost would be $99
standard formula yes, It can be done, but extremely complicated, a formula would actually take longer then a macro and would not be as efficient.
Keep in mind the following
1. This is how I make a living.
2. The price also includes troubleshooting, if for some reason you cannot run the macro or you get errors, or it doesn't quite work right.
3. The price was arrived at based on my experience which is extensive, this is why I know enough to recommend a macro instead of a formula, I know how excel works and works best.