New Contributor

# How to calculate amount based on different categories?

Hi,

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.

Is it possible to do this?

Thanks

6 Replies

# Re: How to calculate amount based on different categories?

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

# Re: How to calculate amount based on different categories?

@Harun24HR Thank you so much for your help

 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

My 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.

what formula I can use to get these automatically.

# Re: How to calculate amount based on different categories?

I'd use a small lookup table:

Formula in E2 is

=D2*XLOOKUP(B2,\$H\$2:\$H\$4,\$I\$2:\$I\$4)

# Re: How to calculate amount based on different categories?

Thank you so much