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?
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
0
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
0
Saurabh Singh TeotiaCommented:
I didn't get what you mean..when its aed you are saying their won't be any warranty???
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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
0
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
0

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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.