SALES MARGINS

[natalieb]

Hi There

I wonder if someone out there can help. I have 10 rows of sales figures. Some days there were no sales. I want to find the margin but I need the formula to only work the margin out on the rows that have sales greater than zero.

Thanks so much for a fantastic site!!

Natalie

 

[venkat1926]

suppose your sals figures start from A2 in B2 tpe
=IF(A2="","",A2*15%)

copy B2 down.


my margine is sales *15%
when A coumn cells have data you get margin in corresponding B column
if A column cells are blank the corresponding cell in B also be blank

 

[natalieb]

sales margins

HI There

Thanks so much for the quick response. We want to find out what the margin is.

Say I have the following

eg:

Day Sales
Mon 5
Tue 10
Wed 10
Thur 0
Frid 0
Sat 5
Sun 5


I want to know what is the sales margin for the week but I do not want to include those days where there was no sales in my margin?


Regards

Natalie

 

[Peter_SSs]

natalieb

How would you calculate (manually) the sales margin for the week shown in your sample data?

 

[natalieb]

Sales Margins

Thanks so much!!!

 

[Peter_SSs]

Re: Sales Margins

Thanks so much!!!

For what?

If you can tell us what you mean by 'calculate the margin for the week', then I am sure we can tell you how to do it and leave out the days with no sales.

 

[natalieb]

sales margin

I was asking this question on behalf of a co worker and when you asked you question it seemed to jolt back to reality for her. She was actually looking to work out the average sales and not the sales margin

Thanks again

 

[Peter_SSs]

So, to get the average excluding days with 0 sales, one way is:
=SUM(B2:B8)/COUNTIF(B2:B8,">0")

Mr Excel.xls
	A	B	C	D
1	Day	Sales
2	Mon	5
3	Tue	10
4	Wed	10
5	Thur	0
6	Frid	0
7	Sat	5
8	Sun	5
9	Average	7
Average