Aladin..mainly....and anyone who can shed lite?

Oh....and ignor the reailly bad grammer and spooling

Re: Oh....and ignor the reailly bad grammer and spooling

> why +0

We're using it to coerce a boolean, date, time or
text value into a number. For example, "1"+0=1;
TRUE+0=1; "12/1/01"+0=37226 {the date value for
Dec 1, 2001}; "1:05 P"+0=0.545138888888889 {the
time value for 1:05 PM or 13:05}. In effect were
coverting data types. And, by the way ampersand
(&) can be used to convert a numeric or boolean
value into text. For example, 1&""="1";
TRUE&""="TRUE"

> ^ what the heck is that

Excel's exponentiation operator. For example,
2^3=8; 4^0.5=2

thanks Mark...but!

Cheers Mark,

(I have some questions for you too, but I'll look at work)

>Excel's exponentiation operator. For example,
2^3=8; 4^0.5=2

exponentiation?? this is the terminology I was refering to. I know there are thing such as dictionaries. moreover I'd like to find that pocket sized book that says "exponentiation" a type fruit e.g. banana+apple/kiwi or banappwi :)

But the +0, thanks

Ian

More...

> was [=sum(Blah)/countif(blah,">0")]... just over looked

COUNTIF and SUMIF are fairly "new kids" on the block.
They were recently added to help those who didn't
understand array formulas. They have their own
limitations -- they can't deal with multiple cond-
itions. Those of us that have been around for
awhile (I started using Excel in the mid-80's so
I could leverage of the power of array formulas)
have learned to solve problems without them. Basicly,
our preferred formulations are simply a matter of
style (and habit).

Also Mark

I've JUST started looking at other sites, is that you on the http://bbs.elementkjournals.com/ site, if so acn you recommend any others.

Also I've just been promoted! (MUCH, more thanks to this site than my own personal abilities) And I've got to learn Access pretty quick, I've seen people ask for Mr. Access?? on here but never paid much attention. Would you or anyone know of any good sites? And as I've NEVER used it, are there any similarities to excel in term of formulas (I know it's a database package!) (and what a database is!) etc.

Any advise

Ian

Re: Oh....and ignor the reailly bad grammer and spooling

IT WAS OVERLOOKED. HOPE WILL NOT HAPPEN AGAIN. BTW, SUCH OCCURRENCES ARE CALLED "COGNITIVE ACCIDENTS" IN PSYCHOLOGY.

IF YOU HAVE A BOOLEAN EXPRESSION AS PART OF A FORMULA, YOU'LL GET A SET OF LOGICAL VALUES (WHOSE SIZE CAN BE >=1). THE EXPRESSION IS USED COURSE TO COUNT OBJECTS THAT MEET SOME CONDITION. IF YOU FORCE (COERCE) EXCEL TO TREAT LOGICAL VALUES AS NUMBERS (THAT IS, FALSE AS 0, TRUE AS 1), YOU CAN DO A SUM OVER THE SET. FOR EXAMPLE:

=SUM((A1:A5="Apple)+0) [ must be array-entered ]

ANOTHER EXAMPLE:

SUPPOSE THAT A1=0023 & TEXT-FORMATTED. YOU CAN MAKE EXCEL TREAT THIS AS NUMBER BY USING A1+0 OR A1*1.

YES, I'M. LECTURER AT A "COLLEGE" TO BE SPECIFIC.

that's not the question, you and others around this board have (to me) an excellent math base to everything, something I sadly lack. but I feel I would understand a great deal more if I could find a resource re: symbols. i.e. ^ what the heck is that,

^ IS THE SYMBOL FOR EXPONENTIATION, NOT ONLY IN EXCEL BUT ALSO IN LOTS OF PROGRAMMING LANGUAGES. 2^3 MEANS 2*2*2.

leant it at school I think??,

I SUPPOSE YOU SHOULD HAVE. :-)

I have a good head for logic but I'm looking for a good pocket guide to definitions and small e.g.'s for the various wizardry. I've looked all over, but it just big basic-advanced books tellingme I should have payed more attention at school. (hench the teacher/subject question)

THAT'S RIGHT I GUESS. THE LONG AND THE SHORT IS THAT THERE IS ALMOST ALWAYS SOME SUBJECT IN/FOR WHICH ONE NEEDS DIRECT?INTERACTIVE TEACHING (METHOD SOCRATES, IF I MAY SO).

I WILL. I RECKON THAT YOU'RE IMPLYING TO HAVE LEARNED A FEW THINGS HERE, A TEACHING SITUATION THAT GIVES YOU MORE THAN THE TEACHING SITUATION THAT YOU HAD WITH YOUR COLLEGUES. MY CLAIM IS THAT YOU NEEDED TO EXPOSE YOURSELF (DIRECTLY OR INDIRECTLY) TO OTHERS TO LEARN THINGS EXCEL. BEING AN "AUTODIDACT" IN EVERYTHING IS NOT A SOLUTION TO LEARNING.

IT DEPENDS ON WHAT KIND OF COND FORMAT PROBLEM YOU HAVE. USING A FORMULA (AS VALUE OF "FORMULA IS") IS SOMETIMES THE ONLY CHOICE.

I LEAVE THIS TO THE VBA CREW.

YOU'RE WELCOME.

YES, IT IS.

Aladin

Re: Also Mark

> is that you on the http://bbs.elementkjournals.com/ site

Yes... from time to time.

> Would you or anyone know of any good [Access] sites?

The only 1 I know is...

http://bbs.elementkjournals.com/bbs/postlist.pl?Cat=&Board=ima

I use Oracle instead...

Fair Enough.....

It wasn't a dig, just an honest question. I have of late become Exremely concerned about memory my comp at work has 64MB, the chances of getting more, NONE. COMPAC you see! and a tight co.

So as I have you here, in terms of formulas what quick start tips would you give. i.e. Array vs whatever etc.

Any mainly do's and definately DON'T's

Ian

Re: Fair Enough.....

> Any mainly do's and definately DON'T's

Remember that others may have to read and
understand your worksheet designs... so keep
them as straightforward as possible. Don't
mix data types in your data list columns.
If you have a column of IDs (and as such you'll
never perform math on them) store them as
text instead of numeric values.

again

Hello again

I SUPPOSE YOU SHOULD HAVE. :-)

I did Graphic Design for 8 years and at school that's what I wanted to do. I Should/Did/Could have learned the maths things at school but for 8 years I had no use for it and I have simply forgotten most of it!. I bet it's not that often people TRY to get the things they've lost, from school, back and in a determind way. (perhaps I might try clawing back the English thing?? as well)

IT WAS OVERLOOKED. HOPE WILL NOT HAPPEN AGAIN. BTW, SUCH OCCURRENCES ARE CALLED "COGNITIVE ACCIDENTS" IN PSYCHOLOGY

see conversation with mark.

IF YOU HAVE A BOOLEAN EXPRESSION AS PART OF A FORMULA, YOU'LL GET A SET OF LOGICAL VALUES (WHOSE SIZE CAN BE >=1). THE EXPRESSION IS USED COURSE TO COUNT OBJECTS THAT MEET SOME CONDITION. IF YOU FORCE (COERCE) EXCEL TO TREAT LOGICAL VALUES AS NUMBERS (THAT IS, FALSE AS 0, TRUE AS 1), YOU CAN DO A SUM OVER THE SET. FOR EXAMPLE...

Thanks

YES, I'M. LECTURER AT A "COLLEGE" TO BE SPECIFIC.

OOO!

I WILL. I RECKON THAT YOU'RE IMPLYING TO HAVE LEARNED A FEW THINGS HERE, A TEACHING SITUATION THAT GIVES YOU MORE THAN THE TEACHING SITUATION THAT YOU HAD WITH YOUR COLLEGUES. MY CLAIM IS THAT YOU NEEDED TO EXPOSE YOURSELF (DIRECTLY OR INDIRECTLY) TO OTHERS TO LEARN THINGS EXCEL. BEING AN "AUTODIDACT" IN EVERYTHING IS NOT A SOLUTION TO LEARNING.

That's not all. (I wasn't going to do this)
I agree, I have also lectured in university (OOO!), and feel the need for both. That was my point, as it happens I'm booked onto an Excel course simply because I don't feel I've had the best BOUNCING OFF effect of learning that I try to employ (books don't argue back). I feel that although I feel confident enough find an answer on my own (in the end) there are so many things I have not learned through standard teaching of text, e.g. I don't use the full potential of pivot tables, (or know how) simply because I have had not the time or the need at work. Hope that's cleared that up?

IT DEPENDS ON WHAT KIND OF COND FORMAT PROBLEM YOU HAVE. USING A FORMULA (AS VALUE OF "FORMULA IS") IS SOMETIMES THE ONLY CHOICE.

not regarding the statement I put re: today(), now() etc. of course Formula Is has to be used but in this case (which is the the same for all 4 on the board I've answered) there is no messing around with =ETC.()<>=etc.thingy when for example Cells Value Is _ Between _ =TODAY()-30 _ And _ =TODAY()+30

Ian

Re: again

That's OK. Have no problem with it. My bias is that, if I resort to a formula, I activate "Formula is". Hope that's OK too.

Aladin