Is there any way to make an IF Function return the value of another cell, instead of the value stated w/n the function. I am trying to create a summary...

Possibly the code was a bit too long to make any sense of so i'll rephrase the question. Is there a limit to the number of characters a named function/range...

Is there any way to nest more than functions in an IF statment. Example: 90-100 = A etc. can be written as =IF (A289,"A",IF(A279,"B",...

I'm trying to replicate the "fill" option in the edit pulldown. Basically I'm trying to forecast a growth pattern on an annual basis when I know my starting...

I need to count the number of blank cells in a column, including cells that are blank but have a formula in them. Don't think I can use the COUNTA function or...

I would like to create a formula that grabs a value from another multi-sheet file. The workbooks both contain the same number of tabs and all the tabs are...

I want to use the INDIRECT function to capture a reference that is 2 columns to the left of the one in which I'm writing the equation. Unfortunately, if I use...

Is there a way to calculated weighted averages in Excel? Lotus has a function called WEIGHTAVG, this is what I am looking for in Excel. Thanks

I posted a question earlier regarding a lookup function. It did not work correctly. I have a list of names on Sheet 2, Column B(2:21). I want to place a...

i have a workbook with two sheets in it. it is in alphabetical order with 10,000 names on it and other information. i want to "transfer" two columns...

I need to calculate the percentage of "yes" answers in a column. Any suggestions?

I have two sets of data that I am trying to match up by cutting and pasting each into one worksheet, then running the Match function. Both sets of data are...

sir, if i write 1000 in A1 cell, how i can get the english translation of the cell A1. what is the formulae to get the total of many cells in a respective...

How do I make a function where I want the following information. If a certain column contains a value less than or equal to zero then I want the information...

Is there an easy way to get three OR conditions on a Custom AutoFilter? If not, can you suggest a simple way to accomplish this in another fashion? In other...

I need to convert the case from all caps to mixed, and am having no luck. Any ideas.

Is there a formula that works like DSUM, but without the criteria tables associated with DSUM. Oh, and if there is a way to use DSUM WITHOUT a criteria table,...

Hi folks, I have three more questions for you! Don't worry, once I have this spreadsheet working the way I need it to then it shouldn't need much...

I am building a Bidding spreadsheet where I am selecting the Name of my Customer from data validation list. That information is in C3. In C5, I want to be...

Hi ppl, ok 1st of all, what i am trying to do is make a formula on sheet 2 that looks on sheet 1 in column E (from row 3 to 1000 ) for a "variable" wich i got...