The function tag has no wiki summary.
0
votes
1answer
28 views
Emacs - Specific Bracket Behavior Customization
In emacs, I prefer the electric-pair-mode behavior for parentheses and brackets as opposed to what seems like the "jumpy" default behavior.
However, I currently use auto-newline and like the ...
0
votes
2answers
55 views
How can I use multiple IF functions in Excel 2010?
Well, I am putting multiple =IF functions in a particular cell in Excel 2010. The Value if True part of the function is A18*0.5, however when I put more =IFs in the cell then the Value if True is ...
0
votes
2answers
53 views
May someone be able to fix this function please?
Like, what is the problem with it?
=IF(F2>6,=A18*0.5,=A18*0.6)
It keeps on making it just say =A18*0.5, not the actual contents of half of A18.
So can someone try make this work?
All help ...
0
votes
0answers
22 views
OpenOffice Calc; Random selection of cells that have not yet been randomly selected?
In effect, I'm looking to create a table with each cell representing a card in a deck, and I would like to simulate drawing the cards randomly while avoiding drawing the same card (or cell) a second ...
1
vote
2answers
53 views
How do I handle the failure of a command in a bash function?
I have a bash function on one of our test servers that deploys our code, but one of the commands fails frequently and we can't find the cause. We just retry until it works.
I want to have the ...
1
vote
1answer
39 views
Call on a cell in Excel up to the first semi-colon
I am using the =CONCATENATE function, and one of the cells I'm calling on I only want to take the value in the cell up to the first semi-colon. Is this possible, and if so how?
0
votes
1answer
84 views
Easy MS Excel - MIN column with IF condition checking another column
I'm analyzing some personal expenditures for somebody on Excel.
I have a column for calendar dates and a column for expenditures on that date.
Of course, there are days when there are no expenditures ...
1
vote
0answers
342 views
Linux Mint 14 Cinnamon - Fn Keys Brightness Level Intervals
I have a question in regards to setting the brightness level on laptop display using the function keys; I have determined that my screen is capable of having it's brightness level set to values 1-10 ...
2
votes
1answer
26 views
Rename selfdefined function
Having a precmd() that does quite a lot, like checking for VCS information, I want to disable it when I'm navigating on slow mounted network drives.
I came up with the following with which I can say ...
0
votes
1answer
62 views
How to get the data from one cell to alter the function of other cells
I have 10+ worksheets, with the same layouts, all containing data from different days jobs. I am trying to create a "SimpleSheet" that only pulls specific data from one days sheet in a nice layout. So ...
1
vote
3answers
173 views
Display multiple cells if data on another workbook contains “X”value
I export a complex report daily and I transfer that information manually into another excel sheet. My question is: In workbook 1, can I get a group of cells in a row to display the text in workbook 2 ...
1
vote
0answers
26 views
Custom function COUNTIFUNIQUES in Excel [duplicate]
Possible Duplicate:
Excel: how to count number of distinct values in a range?
I would like to create a custom function COUNTIFUNIQUES that extends the functionality of COUNTIFS.
Here is an ...
-4
votes
1answer
46 views
Syntax for Functions in Bash
I do know the JavaScript syntax:
var functionName = function(some perameter){
some code here;
};
but what is the syntax for a function in bash?
0
votes
1answer
122 views
Libreoffice Calc - Fill with Sum is not working
I want to add 2 columns of data and output the sum into a third column, with a =sum(a1+b1). With many rows of data, I try dragging down the highlighted cell to Fill the rest of the output column with ...
2
votes
3answers
92 views
How do I make a bash alias that outputs file names in a format I can pipe to vim?
When rebasing with git, I'm interested to open the files that have merge conflicts.
I can do this with:
vi `git diff --name-status --diff-filter=U | awk '{print $2}'`
but if I alias that:
alias ...
0
votes
1answer
124 views
excel function searching multiple rows
I have a worksheet with a column (A) with dates. Some rows between dates are blank. I want to put a cell on another sheet that searches sheet1, column A for a particular date, and when that date is ...
0
votes
2answers
957 views
change middle mouse button function in Windows
Is there a way to assign a function (like cut / copy / paste) to the middle mouse button or scroll wheel in Windows 7?
2
votes
1answer
603 views
How to return current record number in Access?
I want to have my table to automatically returns current record number.
What functions should I input in default value of this field (indicated in blue arrow) in order to automatically generates ...
0
votes
1answer
258 views
My bash script does not find an existing file (into the script's wd) which name I passed as a parameter in a function
I realized a bash script that works on an existing text file located into the same working directory of the script. The script take name of the file to compute through a function parameter.
The issue ...
0
votes
2answers
170 views
How to divide the sum of cells by 7 and then transpose them in Excel
I need to take a vertical row of numbers in excel and add them all and divide by seven. I then need to transpose the result into 7 equal rows (one for each day of the week.)
I have tried the ...
1
vote
1answer
148 views
overriding user defined functions with the same name as system commands
This function exists in one of my users' ~/.bashrc:
function rm()
{
ls $*
echo "rm?"
read ans
if [ "$ans" == 'y' ]; then
/bin/rm $*
fi
}
In ...
1
vote
0answers
53 views
Is there any way to use devices like mp3 players when they are charging? [closed]
The question is simple I think. All we have encounter gagets that they don't fuction while they are in charge, like cameras or mp3 players. But, we know that cell phones or laptops can have full ...
1
vote
1answer
57 views
Returning The Name of the highest value field
I have 4 field of Numeric Values, I want Excel To pick the highest value of them and show me the name of the field that is related to the highest one, for example:
Option 1 (J10) Option2 (K10) ...
1
vote
0answers
20 views
When Caps lock pressed it used to display cap's lock is ON, now it is not showing
When Caps lock pressed it used to display cap's lock is ON, now it is not showing.
Dell studio 1569..re-installed win 7 64 bit.
1
vote
1answer
258 views
Quicker alternative to IF function for multiple variables? (excel 2010)
I have the following information in a table
C D
----------- -----------
1 | 25% | 1 |
----------- -----------
2 | 50% | 2 |
----------- ...
0
votes
2answers
154 views
How do I add a value to a cell in Excel if it's an int?
I have an Excel table with some cells that are numbers and some cells that are strings. I want a function that can add search through the table, and if the cell is a number, add it(+) and if it's a ...
1
vote
2answers
429 views
How to generate a round-numbers graph in Excel?
folks!
Now, I have an Excel file with measurements I made of some color patches (I work at a Press company), with a device called spectrophotometer.
Here it is:
...
0
votes
1answer
267 views
IF function that refers to another cell if true
Can someone please help?
I am using the IF function to find cells within certain ranges, but want the cell to contain the value if it falls within that specific range.
for example:
=IF (AA3 is ...
1
vote
3answers
263 views
Using a pre-existing function for a new row
I have an Excel document that contains X columns and N number of rows.
The very last column of a row performs a SUM of the first X-1 columns. The problem I have is, the user of this Excel document ...
2
votes
2answers
3k views
Excel - define a formula in one cell to be used in other cells with different inputs like a function
I use excel 2010.
I want to use a formula defined in one cell as if it was a user-defined function.
Example:
In A1 I put something like (I know it's not a real syntax):
= 3 * Input + 15
And then ...
1
vote
0answers
88 views
Operating system functions
I am currently reading From Nand to Tetris (aka The Elements of Computing Systems) - highly recommended. Anyway, in the last chapter (which deals with operating systems) it says:
Some functions ...
0
votes
0answers
36 views
Is there a twitter functionality to be selective with retweets?
At times, there are tweets that I would deem appropriate to retweet to specific lists or only to certain followers. I've had much experience using Twitter and third party programs like Tweetdeck but ...
2
votes
3answers
1k views
Can basic mathematics be done in Microsoft Word?
Is there a function of MS Word that enables users to solve basic math problems, in this case addition or subtraction? I use its platform for a budget and of course I could just use a calculator but it ...
0
votes
1answer
2k views
OpenOffice Calc - how to insert BLANK in a formula?
In Calc, as in most spreadsheet applications, an IF() function exists that can be used to control behaviour, for example inserting this formula in cell C1.
=IF(A1>B1;"A";"B")
will display A in ...
0
votes
1answer
36 views
Matlab: How do I put another function within a function?
I have a function in Matlab that produces three specific results. I want to use these results as input arguments to a following function to calculate the end result.
How do I go about combining the ...
0
votes
1answer
626 views
split a large excel into smaller files but include the header in all files
I have a macro that I use to break large excel spreadsheets into smaller files. It works perfectly, except, it only uses the header row in the first file created and this header row (row 1) needs to ...
1
vote
2answers
328 views
Excel macro date parser cannot handle single-digit days
From previous questions on this and other sites I was given a function that can parse for and find dates in text strings or cells. Here's the function:
Function GetDate(strInput As String) As Date
...
0
votes
2answers
410 views
Multiple IF Then Function
I know this shouldn't be this difficult, but what I am looking to do is
I want a total in A5 based on a running total in A1 through A4.
For example, if A4 is blank then input A5=A3, if A3 is ...
5
votes
4answers
5k views
Excel VBA Function runtime error 1004: Application-defined or object-defined error
I'm trying to learn functions for the purpose of simplifying and reusing code whenever necessary.
I began by turning something I use pretty often into a function: Returning the integer value of the ...
1
vote
3answers
394 views
Regular keyboard stuck as if a laptop function key was pressed
I have a regular PC keyboard plugged in a desktop PC with Windows 7
When I switched on the computer today I discovered that pressing U writes '4', O writes '5', K writes '2', etc. exactly as if you ...
2
votes
1answer
339 views
Function which overrides bash command
Is it possible to call a bash command which has been overridden with a function? I'd like to make pushd with no arguments alias to pushd . otherwise get normal behaviour.
I've tried
pushd(){
if [ ...
0
votes
1answer
3k views
AutoHotKey how to pass/evaluate parameters to functions
I'm having trouble understanding how parameters are accessed in AutoHotKey functions.
For example, I set myVar variable with the InputBox, then pass it to a function. How do I evaluate the arg in the ...
1
vote
1answer
588 views
Changing numpad key function when numlock is off?
So I've got a new Acer notebook and the keyboard is laid out like this:
I want to be able to change the left and right arrows of the numpad to volume down and up and the 5 key to mute but still be ...
0
votes
2answers
619 views
.bashrc reports unexpected EOF
I am trying to add some functions to my bashrc, namely:
h () { history | fgrep $1 | sort -u | cut -b 8- }
extract () {
if [ -f $1 ] ; then
case $1 in
*.tar.bz2) tar xvjf $1 ;;
...
2
votes
0answers
698 views
How to add support in Function List for a new user-defined language? (Notepad++ Win7 64bit)
I'm writing in a user-defined language called 'Umajin' (*.u), which has a syntax quite different from C/C++ or any ECMAScript-based language, so we've had to write in the rules for the highlighting.
...
0
votes
1answer
2k views
Function generator for PC soundcards
I'm in need of a function generator, but I want to avoid buying dedicated laboratory instrument. My idea is to use computer's sound card to create signals (yes, I know that it's not a replacement for ...
0
votes
1answer
204 views
When switching to another doc, Function Argument window disappears?
I have problem with Excel 2007 when using VLOOKUP function. After switching to another document for referencing value in "Table_array" field, window dissapears.
Google finds some results about the ...
2
votes
2answers
3k views
Turn off laptop back light without keyboard in Windows 7
How do I turn off my laptop's back light using a shortcut, or a program in Windows 7?
I have a Gateway NV59 and can press Fn + F8 to blacken the screen. At night, while watching a movie on my other ...
0
votes
2answers
60 views
brightness of the screen not adjusted
i have sony vaio vgn series laptop,after xp installtion function keys are not working.....i have installed all appplications n drivers available on sony website n compatible with my model....kindly ...
1
vote
3answers
2k views
Does Excel have a row filtering function (more general version of SUMIF/COUNTIF)
SUMIF and COUNTIF functions are handy for simple SUM and COUNT operations on only some of the values in a range, but is there a more general version that would allow me to plug in any other function I ...
