Link to home
Start Free TrialLog in
Avatar of infiniti7181
infiniti7181Flag for United Arab Emirates

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
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

I believe this is what you are looking for..

Saurabh...
test-2z.xlsx
Avatar of infiniti7181

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
I didn't get what you mean..when its aed you are saying their won't be any warranty???
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
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Amazing . Thats how i expected. Thansk for your support.