LinkBack URL
About LinkBacks
Hi, I need to create a formula in column N that returns the total cost in USD.
It has to be only 1 formula which will:
multiply the volume of part number by part number cost, will use appropriate currency and exchange rate.
Please help
Hi, I need to create a formula in column N that returns the total cost in USD.
It has to be only 1 formula which will:
multiply the volume of part number by part number cost, will use appropriate currency and exchange rate.
Please help
May be in "N3"
copy paste downFormula:
Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Hi Yes, but it's only a part done.
This way I have a sum per part number.
Each part number can be either in GBP or USD or EUR and the sum (price) has to reflect that.
Additionally
I have to use appropriate exchange rate for each currency.
Everything in 1 cell..
Total cost has to be in USD
Try
Formula:Please Login or Register to view this content.
Enter with Ctrl+Shift+Enter
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
I entered with CRTL+SHIFT+Enter and it gives me "part not found" for all of them..
See attached
Or this way with all parts in all currency
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks