Function Related Problems & Solutions

33 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 33
Why does my VBS script skip a function?
Summary: I have a VBS script in an HTA file that looks like this. Though, when I call the drive() function (from outside this code) it for some reason runs dri...

Excel Formula needs to add Index to return cell information
Summary: Hello, Currently I am working with two tabs of data that do not have the same unique identifiers at the same time. I am using a series of functions ...

Working days - specific case
Summary: Hi, My question is more complicated: Introduction: In my country if we have national holiday (like the day of independence of USA – 4th of July) in ...

[Solved] windows 8 driver for lexmark x4975 printer
Summary: Where can I find the full function windows 8 driver for a Lexmark X4975 printer? Dave ...

Routing bootstrap function and definition
Summary: What is a boostrap and what does it do for a router? ...

Print screen key does not work on Logitech keyboard
Summary: Print screen does not function from my Logtech Ultrax Premium Keyboard P/N 868029-0100 PID: ST936JO3756 ...

HTC smartphone camera function not working
Summary: Tried everything to access the camera function with no luck. ...

[Solved] Returning an empty cell if both cells I'm adding are empty
Summary: I would like to write an IF statement in cell A3 that says, IF cells A1 and A2 are both empty (i.e. neither of them has a numbers in it), then leave c...

[Solved] Excel greater than less than?
Summary: If a number in a column is less than 100 I want the function in the next column over to take that number and calculate 15 percent of that number. If i...

[Solved] Combination of macro and Excel formula
Summary: Hi.. I want to combine macro and excel function on a spread sheet but i always have a problem if i combine macro and excel function. if i run only th...

[Solved] I can't find Windows XP search-type function in W7
Summary: The search function in Windows 7 (Top RH corner) is quite useless compared to what I had in Windows XP. ...

[Solved] can't set up the scan function on the Canon mx432 copier
Summary: how to set up the scan function on the mx 432 canon copier ...

[Solved] Using the round function with an if statement
Summary: I'm writing an IF statement to check my math, such that, IF A + B = C, return CHECK, else return ERROR. I'm getting ERROR in cases where the result of...

[Solved] how to find the peak above a certain value of a given range?
Summary: Hello again! The description given in this forum did really help a lot! But now i have a new problem which i couldn't solve until now: I need to buil...

can't get windows update to function
Summary: can't get windows update to function ...

[Solved] Windows Excel 10 IF AND function broken but really simple
Summary: I have the following formula that is returning the words TRUE or FALSE. =IF(AND(L6=1, R6=7),1,0) If L6 equals 1 and R6 equals 7 shouldn't this formula...

PHPMail funcion working intranet not internet
Summary: OK so as the title suggests, I'm having big time issues with my php I am running php 5.2.17 php.ini configured for smtp=mail.mysmtp.com port as well m...

[Solved] How do you separate numbers within a number sting in excel?
Summary: I need to take the 1st and 3rd number in a string and add them together. 6262 --> 6+6=12 624664 --> 6+4 = 10 4533 --> 4+3 = 7 if there a function in e...

[Solved] Nested if returning false
Summary: I am using a nested if statement to determine the date and amount of an investment. The function works in the affirmative but returns false otherwise...

Need help with tiebreaking with rank function in excel
Summary: Excel ranking and breaking ties - I need help to break any ties looking at another cell, and if there is still a tie then to look at a different cell....

[Solved] Looking for an IF AND AND function?
Summary: Is there a way of creating an IF AND AND function in Excel? Is there anyway to create an if function that will work out if one cell contains "X" and a...

[Solved] The sum for looking up various numbers across two sheets
Summary: I have a sheet with patient identifiable numbers in it - I want to see if these patients are in another sheet with their identifiable numbers - What i...

[Solved] Using RANK function with more than 1 equal value.
Summary: I am using the RANK function to rank a list of tenants by rental income on my rent roll and then using Vlookup in a separate table to generate a summa...

[Solved] Excel Problem (referring to cell contents in function)
Summary: I have two worksheets, one with debits categorised by date in the first column, then the amount of the debit. The second worksheet is a total of credi...

[Solved] 2 Drop Down List for Single Dependent
Summary: I need help... Is there a way to create 2 seperate drop down lists for a single dependent? I have two columns that I need to have updated depending o...

Find & copy value2 based on value1, 2 sheets
Summary: I have two spreadsheets in Excel. One has a list of names and a blank column next to it for their respective jobs: Lastname Job (blank) The second ...

Nested If Statement, Ranges?
Summary: I'm making a spreadsheet to track whether course prerequisites are being met by the recommended course sequence at the university where I work. What I...

Keyboard keys
Summary: I was cleaning my laptop the other day, (cleaning the stuff between the keys) I removed several keys to clean better. I had done this before with no p...

Volume & Function Key: Not acting right...
Summary: Normally when I adjust volume level on my two month old Acer laptop I hit Fn + Up or Down (which controls the volume). When I do that I see a graphic ...

[Solved] Batch 'and', 'or', ect help
Summary: Is there 'and', 'or', etc. functions in Batch files? and if so can i have a list of all you know? ...

12


Ask Question