Automatic calculation as per condition code.

[Bibhuti Mohanty]

Dear All Experts,

I would like to thank you for the great helpful tips & guide on excel as it is help to gain a lots of trick. I have some requirement here for automatic calculation the cell as per the condition type mention. we have mention a daily worksheet for outward movements of material to vendors. so the condition type is vary from each.so when we put a condition code on a cell for the reference of vendor, we want to the another field will be automatically calculated. for your reference please go through the attached sample file.

Thank you again for considering the message. waiting for your valuable reply.

Thanks & regards,

Bibhuti

 

[Hui]

Bibhuti

I used this in M2:
=CHOOSE(MATCH(C2,$P$2:$P$7,0),0,I2+L2+K2,I2+L2,0,0,I2+L2)+K2
Copy it down

But see what it means in the attached file:

Note: That because all cases include VAT/CST I changed column K to 2%
Then for the cases where it is 4% I add it again