# Tagged Questions

**-1**

votes

**1**answer

33 views

### Excel - Concatenate words separated by “_”

I need help with the following problem:
My column in A2 in Excel has the value: TB_PLACES_NAMES
But I need to separate the "_" from the others words in the same column.
I've tried this function:
...

**0**

votes

**2**answers

3k 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

**2**answers

59 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

**1**answer

139 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

**3**answers

902 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 ...

**0**

votes

**1**answer

234 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 ...

**1**

vote

**1**answer

2k 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 |
----------- ...

**3**

votes

**2**answers

4k 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

**2**answers

421 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
...