MrExcel Publishing
Your One Stop for Excel Tips & Solutions

criteria and formulas


Posted by lisa braccili on April 18, 2001 6:32 PM

I would like to able to have Excel give me a value if the dollar amounts have increased or declined due to revenue results dropping from a month to month basis. Which is the easiey way to do this?

Help!!


Posted by Malc on April 19, 2001 2:00 AM


Assume Dollar amounts = gross sales less cost of sales
So the problem is has my net revenue changed because gross sales have changed or because cost of sales has changed. So
You will need a formula to establish the ratio between the varibles net revenue and cost of sales and net revenue and gross sales. i.e divide one into the other and see if what has changed. Otherwise reword the problem and have another go