Sum formula choose calculation by wastages

[iqubal82]

Dear Experts,

There is two types of sales calculation choosing by either one wastage type.

If I choose (Type-1 = Wastage) calculation the "D6" cell will be blank

If I choose (Type-2 = %Wastage) calculation the "D5" cell will be blank

The both calculation value will be set in "E11" cell.


I want two formula in one cell.

Refer the attached sample excel range here and help.


Thanks a lot,

STONE SALES SAMPLE.xlsx
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
2	STONE SALES CALCULATION TYPE-1		STONE SALES CALCULATION TYPE-2
3	ITEM NAME	BLUE SAPHIRE	ITEM NAME	BLUE SAPHIRE
4	WEIGHT KG	20	WEIGHT KG	20
5	WASTAGE	2	WASTAGE
6	% WASTSGE		% WASTSGE	10
7	RATE	100000	RATE	100000
8	FREIGHT	1000	FREIGHT	1000
9		2201000		2201000
10
11		Sample	2201000	Here I want any one of value by calculate two types of Wasthge with suitable formula please help.
Sheet1

Cell Formulas
Range	Formula
D5	D5	=D4*10/100
D9	D9	=SUM(D4:D5)*(D7)+D8
F9	F9	=SUM(F4*(1+F6/100)*F7+F8)

 

[jasonb75]

Is this what you mean?

=SUM(D4:D5)*(1+D6/100)*D7+D8

 

[iqubal82]

Is this what you mean?

=SUM(D4:D5)*(1+D6/100)*D7+D8

Dear jasonb75,

Yes exactly, Excellent the formula works fine.

Lot of thanks,

 

[iqubal82]

Dear jasonb75,

Yes exactly, Excellent the formula works fine.

Lot of thanks,

I could not understand the 1 number inside the formula for what can explain please.

Thanks,

 

[Fluff]

Cross posted Excel formula for same any one of value by wastage type

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.