Formula for getting Discount & Net Amount

[rush2rajen]

Hi Excel Gurus,

I had attached a file wherein I had done manual calculations but I am unable to get the same in the required column.
I somehow know that Index, sumif formula needs to be given in it but I cannot get it right.

Please help.


Thanks
Raj

 

[NARAYANK991]

Hi Raj ,

See if this is OK.

Narayan

 

[rush2rajen]

Thanks a lot Narayan Sir. It works.

Thanks
Raj