excel calculation queries

infiniti7181
infiniti7181 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2015

Commented:
I believe this is what you are looking for..

Saurabh...
test-2z.xlsx

Author

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
Top Expert 2015

Commented:
I didn't get what you mean..when its aed you are saying their won't be any warranty???
Expert Spotlight: Joe Anderson (DatabaseMX)

We’ve posted a new Expert Spotlight!  Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.

Author

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
Top Expert 2015
Commented:
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

Author

Commented:
Amazing . Thats how i expected. Thansk for your support.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial