hello.
I have this following peace of code which works fine.
=IF(OR(A13={"UNITED STATES","JAPAN"}),A13,"")
I would like JAPAN to be printed in red and UNITED STATES in bleue.
How would I add this restriction in the code, if it is possible?
Thanks.
Dear all.
this is the first time I am using SAS to model. I have data from a fish study and would like to use SAS to build a model.
As a first step, I looked in the SAS help and found this interesting example.
I need to understand few things in this example:
1. are the key words 'endogenous'...
Hello all.
I am looking for a free software to compare two excel files. I downloaded ExamDiff but it does not work properly.
Do you have any suggestions?
Thanks.
Hello all.
When i specify rows to repeat at top when printing,i get page breaks in the middle of the page. If i print without this feature, there is no problem!
thanks for any hint.
Hello.
I receive a publication by email regularly. I would like to forward it automatically to someone else.
Could give me a hint on how to do this?
Thanks.
Hello,
if column 1 contains the word 'snow', i would like column 3 to show the word 'snow'.
if column 1 were made of only one word, it would have been easy: IF(A1="SNOW", "SNOW","")
How do I do it when column 1 contains any string that might include the word 'snow'?
Thanks.
Hello.
I would like to use OR in a IF statement.
The one I have right now is : =IF(A13="UNITED STATES ",A13,"")
what I would like to do is : =IF((A13="UNITED STATES " OR A13="JAPAN"),A13,"") but I get an error.
The search function is not working on this website.
Thanks.
Hello.
After 4 years, my laptop is getting extremely slow.
I would like to format my disk. I would like to know if the 2 sites I found are OK in their instructions.
1. http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/win_format.mspx?mfr=true
2...
Hello.
I copied a column of numbers from another sheet. Now, the numbers are stored as strings.
I used "Data", "Text to Columns" but it still does not work!
Is there anything I could use?
Thanks.
Hello.
I would like to learn to use the Excel statistical tools (ANOVE, Regression...)
Would you mind to suggest a good tutorial.
I am also looking at Analyse-it add-in. Any feedback on this software ?
Thanks.
Hello.
I have charts in excel sheets. I am trying to insert these charts as pictures but they are inserted as excel files (when I double click the chart in powerpoint, the whole excel sheet opens).
At home, I do not have this problem. I copy the chart then right click in powerpoint and choose...
Hello again.
I have a column chart. Each rectangle represents represents several categories. I would like to show the total for each rectangle.
example:
year cat.1 cat.2 total
1990 2 3 5
1991 6 3 9
If I draw a column chart of cat.1 and cat.2...
Hello.
I have a very long excel document. When I scroll down (or go to the last record), I lose my column titles. I know there is a way to always show them on the screen, but I cannot find it.
Thanks in advance.
Hello.
I have an excel file that comes with strange characters: *.*
I would like to replace these characters by the number 0. I tried with the IF function but it did not work. I guess I did not use it right.
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.