# Questions tagged [worksheet-function]

Questions about using in-cell functions/formulas in spreadsheet software.

**0**

votes

**0**answers

16 views

### In the same worksheet of Excel, I need to pull data from a cell and have it copied into another cell as I type it in

I will try to explain this as simply but as detailed as possible.
Data(data will be letters not numbers) in cell A1 will have corresponding data for cells F1 and G1. There will be more data in A1 ...

**0**

votes

**1**answer

12 views

### Excel formula for sum of income over multiple years adjusted for inflation

I have the income X, and the number of years in the future Y, and the inflation Z. I can calculate the compound interest simply by CI(Y) = X*(1+Z)^Y for any given year, but how can I construct a ...

**0**

votes

**1**answer

17 views

### Find and move cell content in excel

I have a client list that contains name, address, city, state, zip code and some randomly have an email address. I need to move the email address out of the address column into a separate column on ...

**1**

vote

**0**answers

9 views

### How to use old dot notation for ranges in Excel formulas?

As a veteran spreadsheet user I am accustomed to using dots for ranges. Excel supported this in previous versions: For example, if I entered =sum(b2.b21) then when I hit enter Excel converted it to =...

**6**

votes

**6**answers

459 views

### Apply any formula n times without using VBA?

I have the following cells:
A1:
justsometext
B1:
3
C1:
=DOSOMETHING(A1)
I want to apply the formula in C1 n times (n being 3, the value in B1), so in this case it would mean:
C1:
=DOSOMETHING(...

**0**

votes

**0**answers

22 views

### Work related project Excel 2010

I am by far not an expert and am only beginning to see the complexity that is Excel. I am trying to write a formula (if it is even possible) that will allow me to make a condition that if a certain ...

**0**

votes

**0**answers

19 views

### Excel Questions with lots of different problems [on hold]

I'm developing a spreadsheet that will chart the Relational Value of a client.
I'll likely need several separate formulas, but struggling with all of the formulas.
What I would like to have ...

**-1**

votes

**0**answers

22 views

### Find position of first uppercase in excel string [on hold]

This is my first attempt at "Q&A style".
There are many reasons why you may need to find the position of first uppercase character in an excel string. There are lots of resources on the web that ...

**0**

votes

**1**answer

30 views

### A text box which is visible across all the worksheets

I have an Excel workbook with 8 worksheets. I want to create a TextBox with an arrow attached to it and place it at the bottom left Corner, right above the worksheet's names. I want this text box to ...

**0**

votes

**0**answers

33 views

### Excel formula Function [on hold]

I have to update the below user name one by one in 10 counts wise, after make the filter below mentioned points ( A & B Points )
if any formula or VB please help me.
SR.NO User Name
1. ...

**0**

votes

**2**answers

20 views

### How to make addresses populate from one spreadsheet to another

I have two excel sheets of store #'s/event details and another one of all the store number addresses. Not every store gets an event so just copying and pasting all the addresses wouldn't be an option. ...

**1**

vote

**3**answers

36 views

### Excel saying too many arguments for IF/AND/MONTH function

I need it to produce orders that are in Canada or Mexico, over $1,000, and in the month of July. The formula I am trying to use is:
=IF(OR(A2="Canada","Mexico", IF(C2>1000, "Ship by Air", IF(...

**0**

votes

**1**answer

41 views

### How to move values from one column to another based on matching values from other columns

Example of what I'm trying to do:
Hopefully the attached image helps you understand what I'm going for.
I have 2 massive Excel files, one with names & income in the column next to them and ...

**0**

votes

**0**answers

56 views

### How do I get one cell to reference two other cells, so its selections change off those two?

I am making a write up sheet for my company for employees. They want me to make it as simple as possible to stop errors. I need help with the employee name selection. Basically, there is 3 positions (...

**8**

votes

**5**answers

3k views

### Combining first two letters from first name and first two letters from last name

I have a spreadsheet of usernames.
The first and last names are in the same cell of column A.
Is there a formula that will concatenate the first two letters of the first name (first word) and the ...