Excel 'IF' Function - HELP..!!

lttra4

New Member
Joined
Mar 31, 2011
Messages
4
<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>
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
curious, I tested this:
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)))))))))
and there doesn't seem to be a problem?
what exactly is the error?
 
Last edited:
Upvote 0
I can't see anything wrong it's when I try to add more currencies to the formula it wont allow me to do so....

I get the error msg...."your formula contains an error ..etc" pop-up. After I close the pop-up it highlights the 'IF' word like below:

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)))))))))

Are we able to post screendumps? I just tried but it didnt let me.




-- removed inline image ---
 
Last edited:
Upvote 0

Forum statistics

Threads
1,224,561
Messages
6,179,522
Members
452,923
Latest member
JackiG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top