infiniti7181
asked on
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
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
ASKER
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
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
I didn't get what you mean..when its aed you are saying their won't be any warranty???
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Amazing . Thats how i expected. Thansk for your support.
Saurabh...
test-2z.xlsx