<div>
It should be like this....<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41772679-1"><span>=IF(K6=&quot;USD&quot;,Z6,IF(K6=&quot;SAR&quot;,VLOOKUP(X6,ExchangeRates_tony,2)*Z6,IF(K6=&quot;EUR&quot;,VLOOKUP(X6,ExchangeRates_tony,2),IF(K6=&quot;GBP&quot;,VLOOKUP(X6,ExchangeRates_tony,2)*Z6,IF(K6=&quot;JPY&quot;,VLOOKUP(X6,ExchangeRates_tony,2)*Z6,&quot;&quot;)))))</span>
</code></pre>
<br />
The same formula can be written as below since all your calculations are same for currencies other than USD.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41772679-2"><span>=IF(K6=&quot;USD&quot;,Z6,VLOOKUP(X6,ExchangeRates_tony,2)*Z6)</span>
</code></pre>
</div>


<div>
Thank you. &nbsp;I have a follow up though. &nbsp;I am not getting the correct exchange rate. &nbsp; Do you see anything that might cause? &nbsp;I have to run outside for a bit and will be back after while. &nbsp; if it matters, X6 if a vlookup itself. &nbsp;<br />
<br />
thank you
</div>


<div>
I needed False. &nbsp;Thank you very much!
</div>


<div>
You're welcome. Glad to help.
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I have an error with the below: &nbsp;&quot;Too many arguments&quot;<br />
Do you see where I have the error? &nbsp;<br />
Any cleanup modifications are welcome. &nbsp;<br />
<br />
=IF(k6=&quot;USD&quot;,Z6,IF(K6=&quot;SAR<wbr />&quot;,VLOOKUP(<wbr />X6,Exchang<wbr />eRates_ton<wbr />y,2)*Z6),I<wbr />F(k6=&quot;EUR&quot;<wbr />,VLOOKUP(X<wbr />6,Exchange<wbr />Rates_tony<wbr />,2),IF(K6=<wbr />&quot;GBP&quot;,VLOO<wbr />KUP(X6,Exc<wbr />hangeRates<wbr />_tony,2)*Z<wbr />6),IF(K6=&quot;<wbr />JPY&quot;,VLOOK<wbr />UP(x6,Exch<wbr />angeRates_<wbr />tony,2)*Z6<wbr />))<br />
<br />
thank you
</div>
</div>


Hello Experts,

I have an error with the below:  "Too many arguments"
Do you see where I have the error?  
Any cleanup modifications are welcome.  

=IF(k6="USD",Z6,IF(K6="SAR",VLOOKUP(X6,ExchangeRates_tony,2)*Z6),IF(k6="EUR",VLOOKUP(X6,ExchangeRates_tony,2),IF(K6="GBP",VLOOKUP(X6,ExchangeRates_tony,2)*Z6),IF(K6="JPY",VLOOKUP(x6,ExchangeRates_tony,2)*Z6))

thank you

If statement and Currency Exchange Rates

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.