excel calculation queries

Folks,

could you please help me out the following

1. once vendor and sub group is selected , curresponding discounts are showing automatically. now for the highlighted, it needs to be mulitiply with the corresponding cell, when the vendor and subgroup is selected. could you please advise , how we can adchieve it

2. one of the other objective is , when i enter the value as price and select currency , the final cells should be automatically converted to aed . if i select the prices and currency aed , of course there would be no change . how can i acheive this

any advises

Regards,
Sid
test-2z.xlsx
infiniti7181Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saurabh Singh TeotiaCommented:
I believe this is what you are looking for..

Saurabh...
test-2z.xlsx
infiniti7181Author Commented:
Thanks for the solution .

Could you please update me that in  the excel sheet the prices match for eg: i see there is differnce in price in AED , where it should be same for warranty .

Regards,
SID
Saurabh Singh TeotiaCommented:
I didn't get what you mean..when its aed you are saying their won't be any warranty???
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

infiniti7181Author Commented:
Hi
Thanks for the response.

What i require is the following

1. when i categorize as vendor and subgroup , lets say cisco + product , corrsponding disounts will comoe automatically.it works fine .

Now what is not working or not added in the sheeet is
1. when i enter unit price and select respective currency, coversion should take place. i see there is some mismatch in conversion , as i tested with unit price in AED , which should be same in the total value .
2. Also , when warranty is selected in subgroup, there is no customs charge to add , ie , in the cisco , if i mentioned 1.07 , it is only meant for product , so for warranty it shouldnt be multiplied with 1.07

Could you please help

REgards,

SID
test-2z1.xlsx
Saurabh Singh TeotiaCommented:
Their you go i changed the formula to pick only in the case of product..Not in case of warranty..

In additional for AED it's showing as zero as you didn't had C&S mentioned for product aruba..as soon as i mentioned it as 1.. It gives me desired results..

Saurabh...
test-2z1.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
infiniti7181Author Commented:
Amazing . Thats how i expected. Thansk for your support.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.