DiscussWorldIssues - Socio-Economic Religion and Political Uncensored Debate

DiscussWorldIssues - Socio-Economic Religion and Political Uncensored Debate (http://www.discussworldissues.com/forums/index.php)
-   General Discussion (http://www.discussworldissues.com/forums/forumdisplay.php?f=27)
-   -   Excel Help (http://www.discussworldissues.com/forums/showthread.php?t=120520)

diegogo 04-02-2007 10:18 PM

Excel Help
 
Don't know that it has those kinds of formatting conditions. Probably your best bet is to do it the stupid way. So your A column would be amount, B column would be currency, C would be exchange rate to shekels, D would be amount in shekels, etc.

Added bonus is that this is database import-friendly and doesn't lend itself to inadvertently getting figures losing currency context due to formatting changes (happens surprisingly frequently in my line of work). Anybody gives you grief on doing it the stupid way, just say that you're planning ahead.

Good luck.

Idorsearogele 04-02-2007 11:04 PM

if you upload the excel I could probably solve it.

it is hard for me to think outside of excel context.

ORDERCHEAPVIAGRASOFTWARE 04-02-2007 11:24 PM

try the function "Cell"

info type is "format"

should return a code that differs for different currencies. Then you can take it from there.

and have a "zissen pesach."

DagoIgnog 04-02-2007 11:33 PM

cell(info_type, reference) will return format information, but it won't return which currency, sorry. AFAICT the function doesn't exist.

ziIReIGS 04-02-2007 11:40 PM

Originally posted by Kuciwalker
cell(info_type, reference) will return format information, but it won't return which currency, sorry. AFAICT the function doesn't exist.
I just tried it, using some cells formatted as currency dollars, and some as currency euros. It returns different values, because Excel thinks those are different formats.

mr.memo 04-02-2007 11:42 PM

Originally posted by Kuciwalker
It didn't for me, using USD and GBP. I actually used USD (with a dollar sign) and French (Belgian - dont ask me why) with a euro sign. I guess if you only have three character alpha, rather than a currency sign, Excel thinks its the same format.

Which seems odd.

spacecrafty 04-02-2007 11:48 PM

I noticed that too.


All times are GMT +1. The time now is 06:18 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2