Get Commodities Get Commodities And Futures Info Here

Commodities Zinc Copper

Help me on excel formula that is on if condition ?

=IF(D2=COPPER,”1000″,IF(D2=CRUDEOIL,”100″,IF(D2=GOLD,”100”,IF(D2=GOLDM,”10”,IF(D2=LEAD,”5000”,IF(D2=MENTHAOIL,”360”,IF(D2=NATURALGAS,”1250”,IF(D2=NICKEL,”250”,IF(D2=POTATO,”300”,IF(D2=SILVER,”30”,IF(D2=SILVERM,”5”,IF(D2=ZINC,”5000”)))))))))) where as in D2 random commodities comes pl help me ???? thanx in advance

You can only nest a few IF statements (7 I think) so if you have more than 7 commodity names then IF is not the way to go.

A better solution is to set up a table on sheet2 with 2 columns. Column A has the commodity name, column B gas the price (or whatever it is)

Then, assuming your table is in A1:B10 and your commodity value to be compared was in A1 on the first sheet you would use a VLOOKUP folmula instead of the IF formula as follows:

=VLOOKUP(A1, sheet2!A1:B10,2,false)

you will get a #n/a error if your commodity is not in the table at all, otherwise you should get the price back.

Bearish on copper, zinc: Sushil Global Commodities

LH Zinc Copper Insert Putter $14.99 The Zinc putter features a copper insert surrounded by black polymer to provide an extraordinary, soft, buttery feel.*Putter features stainless steel construction *Measures 40 inches long x 5 inches wide x 5 inches deep *Model number putter.zp106pc

Commodities Demystified $16.88 The author explains how the commodities market works and shows investors how to identify and track commodity opportunities in this self-teaching guide that takes the confusion out of the basic trading concepts in commodities. Original.

Commodities for Dummies $16.33 Since 2002, commodities have outperformed every other asset class including stocks, mutual funds and real estate. If you’re itching to get in on the fun and profit, Commodities For Dummies is the resource you need to find out how to break into the commodities market and understand how to trade and prosper. You’ll discover: *How commodities stack up against other investment vehicles *How to identify, manage, and overcome risk *The pros and cons of futures, equities, ETFs and mutual funds *Specific techniques for analyzing and trading in commodities *Powerful profits in energy *— *crude oil, natural gas, coal, nuclear, and alternatives *What you need to know about trading in metals *— *precious and not-so-precious *How to grow your portfolio with farm products Featuring time-tested rules for investment success, this comprehensive, user-friendly guide helps you minimize risk, maximize profit, and find the shortest route to Easy Street.

Getting Started in Commodities $12.37 An introduction to the commodities market shows readers how to successfully invest in futures, stocks, stock indices, and options, explaining how the commodities market works, how to identify and track investment opportunities, the fundamentals of money management, how to find the right broker, and more. Original.

The Commodities Investor (Paperback) $18.8 Commodities make the world go around. They feed, drive and help manufacture a plethora of everyday items. In 2007/08 the world`s population witnessed the commodity story reaching epic proportions. Rising demand, coupled with limited supply as well as volatile stock markets, all merged into a perfect storm to push up the cost of resources and agricultural commodities across the globe. This soaring want and need for everything from oil to gold, from corn to natural gas sent markets, investors and the media into a frenzied state. But many believe this occurrence was not just random hyperbole – demand for energy, metals, both precious and industrial, alongside agricultural commodities, especially from the vast populations of world`s emerging economies, such as China and India, was insatiable. The aim of this book is to help private investors understand the story and themes driving the major commodities in the primary resource sectors energy, base metals, precious metals and agriculture

Commodities, Trade, Finance for Economic Devleopment (Hardcover) $103.95 This book examines commodities, governance and economic development under globalization.

$12.1 Used – The world has changed and so too has investing. The market is shell shocked and yesterday’s momentum stocks are today’s slow-motion stocks. But in the new reality of low-growth investing, commodities are hot and getting hotter. A rapidly industrializing and urbanizing Asia will be demanding lots more copper, zinc, iron ore, coal, fertilizers, gold and oil to transform their societies. Commodities are it and that’s great news for investors who want to profit from the next great bull marke

$12.1 New – The world has changed and so too has investing. The market is shell shocked and yesterday’s momentum stocks are today’s slow-motion stocks. But in the new reality of low-growth investing, commodities are hot and getting hotter. A rapidly industrializing and urbanizing Asia will be demanding lots more copper, zinc, iron ore, coal, fertilizers, gold and oil to transform their societies. Commodities are it and that’s great news for investors who want to profit from the next great bull market