The function tag has no wiki summary.
2
votes
2answers
35 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 ...
0
votes
0answers
43 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
28 views
How to restore (Ctrl + Tab) default funtions?
My (Ctrl + Tab) function is now over-ridden whenever i press (Ctrl + Tab) it is not working
in Firefox for switching between opened tabs and not working in any other program that uses this shortcut, ...
0
votes
0answers
26 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 ...
1
vote
3answers
103 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
402 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
25 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
193 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
133 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
0answers
26 views
Wordpress custom loop [closed]
Guys my question is not related to any problem i have in wordpress but regarding the functionality of wordpress while loop , if you have been building wordpress themes than you might be sure about the ...
0
votes
0answers
28 views
XSLT: how do I get to 3rd normal form with XLT?
Here's an example XML file:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Edited by XMLSpy® -->
<catalog>
<cd>
<title>Empire Burlesque</title>
...
0
votes
2answers
116 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 ...
0
votes
0answers
23 views
How do I delete User Functions in the Microsoft PowerToy Calculator (PowerCalc)?
It's easy to define functions by doing double(x) = x * x and they will automatically appear in the Functions → User Functions menu, but I can't for the life of me work out how they can be deleted.
A ...
5
votes
4answers
1k 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 ...
0
votes
3answers
222 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 ...
1
vote
1answer
178 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
977 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
377 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
373 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 ;;
...
1
vote
0answers
501 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
737 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
158 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 ...
0
votes
2answers
1k 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
49 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
397 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 ...
0
votes
4answers
2k views
Function key emulator for Dell inspiron 6400 on external keyboard
I have a 3 year old Dell inspiron 6400 with windows 7 and ubuntu 9.10 dual boot. I messed up my Laptop keyboard and hence my Fn key is not working and I need it to activate the wireless whose ...
4
votes
1answer
326 views
How do I unset or get rid of a bash function?
If you set or export an environment variable in bash, you can unset it. If you set an alias in bash, you can unalias it. But there doesn't seem to be an unfunction.
Consider this (trivial) bash ...
1
vote
1answer
127 views
Replicating common Excel Functions
I am always curious how some of the functions I use in excel were written, and think it would help at times to see how it was done.
Does anyone know where there is example vba that replicates what ...
1
vote
2answers
187 views
Conditional Lookup in Excel
I want to use excel to compare pairs of numbers from the "Pre/Post" column of the following data:
Student Course Pre/Post Score
K300997203 FHS120100417 Pre 3
L286197217 ...
5
votes
5answers
315 views
Finding the definition of a bash function
I work in an environment that has a lot of legacy shell script magic lying around. One thing used heavy from the command line are bash functions that get sourced from some file included from some ...
2
votes
2answers
112 views
How can I get the place where a function is defined in VIM quickly?
I've installed taglist and nerdtree plugins, and I wonder if there's way to quickly find the location where some function is defined, just as what Control and pressing function name in Eclipse does? ...
1
vote
3answers
326 views
How do I assign a number value to a non-numerical value in Excel
Greetings
I have an some survey responses with values like "VU" for "Very Unlikely" and "S" for Sometimes. Each survey response occupies a cell. For each cell containing a survey response, I want to ...
1
vote
1answer
150 views
Shell function parameter
Is there a way to declare and pass parameters for shell functions, like so ?
function msg( m )
{
read -p "Task #" + m + "done. Press any key to continue
}
4
votes
3answers
429 views
How can I invoke a function in bash shell script
I just wonder the distinction calling the function between $(one_function) and one_function in bash shell script.
When I set the variable PS1 in ~/.bashrc, I can't invoke the function by one_func
...
1
vote
3answers
369 views
Access 2007: How can I make this EXPRESSION less complex?
Access is telling me that my new expression is to complex. It used to work when we had 10 service levels, but now we have 19! Great!
My expression is checking the COST of our services in the ...
0
votes
2answers
140 views
EXCEL generate a character in one column of a row, only if other columns in the same row are not blank
My speadsheet keeps track of when patients leave a specific floor of the hospital. There are columns in which where each patient goes is documented (1 column for "home", another column for "rehab ...
1
vote
1answer
339 views
Office 2008 Mac Calendar Wizard
I remember Office 2004 had a calendar wizard so that I can generate monthly calendars for a range of months. Like print out calendars from Jan 2010 to July 2010.
I cant seem to find the wizard or ...
2
votes
2answers
655 views
Excel Table lookup with indexes in multiple columns
I have a Table in Excel the looks about like this:
Test1 100 test2 200
Test3 110 test4 210
Test5 120 test6 220
I want a function that, given test 1 as input, will return 100 AND given ...
0
votes
1answer
582 views
Vim: Custom Folding function done, custom highlighting required
I have defined a function in vim to properly indent folds. Ie so they look like this:
Unfolded
this is text
also text
indented text
indented text
not indented text
folded with default ...
1
vote
1answer
55 views
Return the date of the day under an if formula with Excel or VBA
I have two columns A and B and many lines with some specific tasks to be done. In column B, I have a drop-down list with the name of people who are scheduled for the task . And in column A, I want the ...
5
votes
4answers
3k views
How to call bash functions
Maybe I am looking at this the wrong way.. But here I what I am trying to do. Do most of my work with Java but just switched to a unix (bash) environment. I am doing this:
[~/Desktop/bashPlay]% ...
3
votes
3answers
3k views
How can I switch the function and control keys on my laptop?
I have an ASUS X51R laptop and the left function/control keys are swapped as shown in the picture below?
Is there some way to remap these keys so that CTRL is on the far left as on a standard ...
1
vote
1answer
60 views
GNU BC: functions, if-clauses and returns
The questions are in the comments of the code:
define f(x) {
print x^2
}
define g(x) {
print x+2
}
if(f(2)>g(1)) {
print "it works"
}
43 # Why 43 instead of the text "it works"?
a=f(2)
...
0
votes
3answers
119 views
Is a shell function better than the same function in PATH?
I have been slightly confused about the extraneous use of shell functions.
My definition of a shell function: a function which is in .bashrc such that
.bashrc
--- other default bash configs ----
...
