How to calculate amount based on different categories?

Question

Hi,&nbsp;I have worksheet with the following:Procedures; subcategorized to a,b,c and I want to calculate the amount for each one of them based on specific formula. e.g. if a, amount= 50/100 but if b, amount= 30/100.&nbsp;Is it possible to do this?&nbsp;&nbsp;Thanks

harun24hr · Answer

Yes, possible. Attach a sample file and show your desired result.

saalgarni · Answer

Harun24HR&nbsp;Thank you so much for your help&nbsp;&nbsp;Procedure&nbsp;CostMy shareDateEMG1630315DateEMG13533DateEEG2344DateNCS36685Total&nbsp;71336397My share should be based on 2 conditions. 1- type of procedure in Column two. 2- Cost.EMG e.g. the amount in my share should be 30% of the cost column. EEG, my share amount is 40% (40/100) of the cost. NCSA, my share is 50% of the cost amount.&nbsp;&nbsp;what formula I can use to get these automatically.&nbsp;Thanks again for your help

hansvogelaar · Answer

saalgarni&nbsp;
I'd use a small lookup table:

Formula in E2 is
=D2*XLOOKUP(B2,$H$2:$H$4,$I$2:$I$4)

saalgarni · Answer

Thank you so muchReally helpful, Appreciatedone more question please,I want D2(cost)=D2 times C2. what formula i can use? I know these questions are basics but would really appreciate help

hansvogelaar · Answer

saalgarni&nbsp;
D2 cannot equal D2 times C2 - that would cause a circular reference and Excel would stop recalculating formulas.
Instead, insert a new column to the right of column D, and insert the formula =C2*D2 in E2.

Forum Discussion

How to calculate amount based on different categories?

6 Replies

Resources

	Procedure		Cost	My share
Date	EMG	1	630	315
Date	EMG	1	35	33
Date	EEG	2	3	44
Date	NCS	3	668	5
Total		7	1336	397