Hello,
Can someone help me with the following:
I am working on a spreadsheet with sales figures
For calculating the margin I take the sales value - cost
For calculating the margin % I take the margin /sales value
When I have a sales value > 0 there is no problem
When I have a sales value which is 0 I am getting in trouble
With a sales value of 0 and a cost >0 I am getting #DIV/0!
With a sales value of 0 and a cost of 0 I am getting #DIV/0!
How can I get a negative margin of 100% when I am selling at 0 with a cost > 0
How can I get a 0% margin when I am selling at 0 with a cost of 0
(I know it sounds mad but we have transactions like this)
many thanks in advance for your help
Can someone help me with the following:
I am working on a spreadsheet with sales figures
For calculating the margin I take the sales value - cost
For calculating the margin % I take the margin /sales value
When I have a sales value > 0 there is no problem
When I have a sales value which is 0 I am getting in trouble
With a sales value of 0 and a cost >0 I am getting #DIV/0!
With a sales value of 0 and a cost of 0 I am getting #DIV/0!
How can I get a negative margin of 100% when I am selling at 0 with a cost > 0
How can I get a 0% margin when I am selling at 0 with a cost of 0
(I know it sounds mad but we have transactions like this)
many thanks in advance for your help