<table><tbody><tr id="r28739387"><tr id="r28739387"><td class="bodytext"> Hi All,
I'm in the process of putting together a new spreadsheet but have come to a stand still as I am facing a problem with one of the IF Function formulas. I've tried everything but cant seem to fix it.
The below formula works absolutely fine:
=IF($C4="gbp/usd",'Pip Value'!$B$2,IF($C4="AUD/USD",'Pip Value'!$B$2,IF($C4="EUR/GBP",'Pip Value'!$B$6,IF($C4="eur/USD",'Pip Value'!$B$2,IF($C4="usd/JPY",'Pip Value'!$B$8,IF($C4="EUR/jpy",'Pip Value'!$B$8,IF($C4="GBP/jpy",'Pip Value'!$B$8,IF($C4="NZD/USD",'Pip Value'!$B$2,0))))))))
But when I try to add one or more additional currency to the fomula it comes up with an error message say ....The formula you typed contains an error. For more info click.......etc...
=IF($C4="gbp/usd",'Pip Value'!$B$2,IF($C4="AUD/USD",'Pip Value'!$B$2,IF($C4="EUR/GBP",'Pip Value'!$B$6,IF($C4="eur/USD",'Pip Value'!$B$2,IF($C4="usd/JPY",'Pip Value'!$B$8,IF($C4="EUR/jpy",'Pip Value'!$B$8,IF($C4="GBP/jpy",'Pip Value'!$B$8,IF($C4="NZD/USD",'Pip Value'!$B$2,IF($C4="USD/USD",'Pip Value'!$B$2,0))))))))
I've checked the amount of brackets, delete a currency pair to test if I would have the same issue, checked the contents of the formula but have no luck.
Can someone please help me on this.
Thanks Heaps...
</td></tr></tr></tbody></table>
I'm in the process of putting together a new spreadsheet but have come to a stand still as I am facing a problem with one of the IF Function formulas. I've tried everything but cant seem to fix it.
The below formula works absolutely fine:
=IF($C4="gbp/usd",'Pip Value'!$B$2,IF($C4="AUD/USD",'Pip Value'!$B$2,IF($C4="EUR/GBP",'Pip Value'!$B$6,IF($C4="eur/USD",'Pip Value'!$B$2,IF($C4="usd/JPY",'Pip Value'!$B$8,IF($C4="EUR/jpy",'Pip Value'!$B$8,IF($C4="GBP/jpy",'Pip Value'!$B$8,IF($C4="NZD/USD",'Pip Value'!$B$2,0))))))))
But when I try to add one or more additional currency to the fomula it comes up with an error message say ....The formula you typed contains an error. For more info click.......etc...
=IF($C4="gbp/usd",'Pip Value'!$B$2,IF($C4="AUD/USD",'Pip Value'!$B$2,IF($C4="EUR/GBP",'Pip Value'!$B$6,IF($C4="eur/USD",'Pip Value'!$B$2,IF($C4="usd/JPY",'Pip Value'!$B$8,IF($C4="EUR/jpy",'Pip Value'!$B$8,IF($C4="GBP/jpy",'Pip Value'!$B$8,IF($C4="NZD/USD",'Pip Value'!$B$2,IF($C4="USD/USD",'Pip Value'!$B$2,0))))))))
I've checked the amount of brackets, delete a currency pair to test if I would have the same issue, checked the contents of the formula but have no luck.
Can someone please help me on this.
Thanks Heaps...
</td></tr></tr></tbody></table>