-1
votes
1answer
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
2answers
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
2answers
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
1answer
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
3answers
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
1answer
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
1answer
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
2answers
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
2answers
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 ...