# foreign

1. ### Using ArrayFormula with Spreadsheet Attached to Google Form Does Not Always Yield Correct Result

I have a spreadsheet that needs to do X, Y, or Z (which are all various sums of columns of numbers) depending upon two variables: If A=5 and B<>0, then do X. If A=6 and B=0, then do Y. Else, do Z. I have a formula that works correctly without using ArrayFormula: =int(if(and(E2="5 courses each...
2. ### IF Statement

Hi all, I have the following table with data and it references against a "lookup" table (column K:L). Somehow I need to combine a IF formula to do all the of the below, have tried doing it with "OR & AND", but just don't seem to be getting it correct. Pending on the combination of Country in...
3. ### Foreign currency conversion using VBA

I do a daily process that requires me to take foreign currency values and convert them into US dollars (USD). For example A1 has the amount of .38 and B1 would have CAD (Canadian Dollar). I then would go to the website XE.com for the conversion rate, search for CAD converted into USD. Take that...
4. ### Reading foreign text in VBA

Hi, I have foreign (non-English) characters in a cell which I was reading using Sheets("data").Cells(1,1).Formula However this returned nothing but questions marks instead of the text:e.g. ζχψωβνιθςεβφ[ςε turns into "????ί????eίf[?e" After research I discovered I needed to set the regional...

### 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.

### Which adblocker are you using?

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

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