| Author |
 Replies: 238 / Views: 8,141 |
|
|
|
Valued Member
Canada
287 Posts |
Edited by rikcando
08/07/2010 1:32 pm
|
|
Pillar of the Community
United States
2669 Posts |
Quote:
Glad to see your in a good mood! I was going through withdrawals again  |
|
Pillar of the Community
United States
2669 Posts |
ERN AWG ANG BBD ZWD YER ETB EUR FJD FKP
|
|
Pillar of the Community
 United States
4000 Posts |
Quote:
ERN AWG ANG BBD ZWD YER ETB EUR FJD FKP 0/0! Nice! |
|
Pillar of the Community
United States
2669 Posts |
By the way Rikcando.. to make it backward compatible to at least Excel 2002, you can use OR instead of IF (returns TRUE/FALSE). Then when you do the SUM it will add any FALSE as 0 and TRUE as 1. =OR(E3=$E$2,E3=$H$2,E3=$K$2,E3=$N$2,E3=$Q$2,E3=$T$2,E3=$W$2,E3=$Z$2,E3=$AC$2,E3=$AF$2) That will at least keep you from having to do the nested IF's  |
|
Valued Member
Canada
287 Posts |
Thanks xshift. I'll certainly try that out next time. It really isn't a compatibility issue for me as I hate 2007 and only use it when a client insists. I don't mind the if's but your method appears more eloquent.
In Excel 2007, the OR function can contain a maximum of 255 expressions. For earlier versions of Excel, the limit is 30 expressions. Much more useful as well.
Edited by rikcando
08/07/2010 2:09 pm
|
|
Valued Member
Canada
287 Posts |
Ok, here's my second for today.
JOD
NOK
RON
TOP
XOF
NAD
PAB
SAR
XAG
ZAR
|
|
Valued Member
Canada
287 Posts |
xshift. I just tested the SUM function and it does not seem to work with TRUE/FALSE in my Excel 2003.
|
|
Pillar of the Community
United States
4000 Posts |
Quote:
JOD NOK RON TOP XOF NAD PAB SAR XAG ZAR Yet another 0/0! I'm showing you should have no more than 128 currencies left to choose from!  |
|
Valued Member
Canada
287 Posts |
WooHoo ! another 0/0 !
xshift, it does work with '=D2+D3' but not '=SUM(D2:D3)'
|
|
Pillar of the Community
United States
2669 Posts |
Strange.. but at least it works with the +. Just checked and that's actually what I'm using (sorry.. lol)
|
|
Pillar of the Community
United States
2669 Posts |
third guess o' the day:
GBP SOS UAH BOB AED BAM GEL GGP GHS GIP
|
|
Pillar of the Community
United States
4000 Posts |
Quote:
GBP SOS UAH BOB AED BAM GEL GGP GHS GIP 1/0! |
|
Pillar of the Community
United States
4000 Posts |
Does it work with =SUBTOTAL(9, xx:xx)?
Edited by Scooby Due
08/07/2010 2:28 pm
|
|
Pillar of the Community
United States
4000 Posts |
Well, if that's it, I'm going to go take a nap.
|
| |
Replies: 238 / Views: 8,141 |
First Page
Posted 08/07/2010 1:29 pm
