No announcements

### Converting Formula to Indirect

I am just learning how to use the =INDIRECT function.  How would I convert the following formula to =INDIRECT? I ...
| 2 Replies | 241 Views | Created by Myysterio - Wednesday, May 18, 2016 8:59 AM | Last reply by Myysterio - Wednesday, May 18, 2016 1:11 PM

### Translating Excel Formula Into Calculated Column Calculation

Goal: I would like to convert a formula that works in Excel into something I can use in a Calculated column in SharePoint. I need this Calculated column to display a ...
| 3 Replies | 6199 Views | Created by richardlpalmer - Tuesday, March 31, 2009 5:21 PM | Last reply by richardlpalmer - Wednesday, April 1, 2009 3:57 PM

### Use INDIRECT with a VLOOKUP

. The ' is to prevent Excel from converting the text value to a date. The formula then ...
| 1 Replies | 15181 Views | Created by nathanliberty - Monday, April 11, 2011 1:20 PM | Last reply by Hans Vogelaar MVP - Monday, April 11, 2011 2:51 PM

### Command to convert text to forumal in all cells

and this is the text in the cell which I want to convert to a ...
| 10 Replies | 558 Views | Created by moondaddy - Monday, February 4, 2019 5:09 AM | Last reply by Ashidacchi - Monday, March 25, 2019 7:02 AM

### min of indirect formula

Try the following formula, which needs to be confirmed with ...
| 5 Replies | 801 Views | Created by Bartek Wachocki - Friday, August 29, 2014 9:08 AM | Last reply by Domenic Tamburino - Friday, August 29, 2014 2:40 PM

### Array Formula + Indirect Reference in Excel

the INDIRECT reference method. What I do not know is, how to create the formula, such that, the template would search all the workbooks, and find the sheet for the ...
| 0 Replies | 5349 Views | Created by exceldr - Tuesday, December 15, 2009 4:25 AM

### User Defined Array Function in VBA

Hi, I want to write a user defined function that behaves like an array a function in Excel (the type where you have to hit CTRL+SHIFT+ENTER. Can this be done? Say ...
| 0 Replies | 3811 Views | Created by Joe Dawson - Thursday, July 5, 2007 5:09 PM

### using VBA to input a INDIRECT formula into Worksheet cell

You have too many quotes. Range("G17").Formula = ...
| 1 Replies | 1576 Views | Created by yourstrulymisterb - Sunday, February 25, 2018 9:55 AM | Last reply by Hans Vogelaar MVP - Sunday, February 25, 2018 12:09 PM

### Dynamically Refering Excel worksheet name in formula

If they are actual dates with number format "mmm-yy" then you can use EDATE formula to get the date previous month. Then use TEXT function to convert to ...
| 2 Replies | 367 Views | Created by Amit Srivastava - Wednesday, November 21, 2018 6:34 AM | Last reply by Amit Srivastava - Wednesday, November 21, 2018 8:46 AM

### Convert to Formulas

in the Pivot Table. Convert to formulas is all about doing you own calculations with some cell values coming from SSAS. BR Thomas ...
| 3 Replies | 3903 Views | Created by nabilas - Sunday, December 13, 2009 7:38 PM | Last reply by Thomas Ivarsson - Sunday, December 13, 2009 8:38 PM

### Convert Excel Formula to SharePoint Formula

Hi Shums, You are not using any SharePoint environment, then why you need SharePoint formula.. and where do you have to ...
| 4 Replies | 1658 Views | Created by Shums Faruk - Friday, February 24, 2017 8:04 PM | Last reply by Navazee Shaik - Friday, March 3, 2017 10:47 AM

### Indirections %==& and ^==*

Does anyone know the difference between indirections % and & as well as ^ and * ? If the ...
| 2 Replies | 3940 Views | Created by bessermt - Thursday, October 12, 2006 4:22 PM | Last reply by Brian Kramer - Friday, October 13, 2006 1:51 AM

### DAX formula to convert date?

Can anybody tell me the DAX formula to convert date as shown below: for example; i have date: 122015 and want to show my date as: December 2015?
| 1 Replies | 779 Views | Created by darkhorse89 - Friday, October 2, 2015 3:03 AM | Last reply by greggyb - Friday, October 2, 2015 4:17 AM

### excel SDK (XLL) and named range with INDIRECT

to that range (xltypeRef).  That function works properly EXCEPT when the formula for the named range includes the INDIRECT function.  That seems to break ...
| 7 Replies | 1251 Views | Created by Kmart92 - Friday, September 5, 2014 7:26 AM | Last reply by Jeffrey_Chen_ - Tuesday, September 16, 2014 8:30 AM

### [Bug] Points in formulas get converted to comma in formulas

Hi! I am struggling with Excel 2013 PowerPivot, because everytime I enter a formula like ...
| 1 Replies | 4510 Views | Created by Andreas Lindenberg - Thursday, November 13, 2014 7:04 AM | Last reply by Ed Price - MSFT - Wednesday, December 31, 2014 2:45 AM

### Convert formula to VBA code

that have been imputed previously instead of deleting each cell I used the VBA program to convert the formula for creating a macro but the VBA ...
| 3 Replies | 994 Views | Created by Old cat woman - Saturday, February 27, 2016 4:02 AM | Last reply by David_JunFeng - Wednesday, March 2, 2016 1:32 AM

### Convert FORMULA to SQL

Lastly another mind blower... need to convert an EXCEL formula into SQL =CONCATENATE(INT(AC2)," days, ",INT(MOD(P2*24,24))," hrs, ",INT(MOD(P2
| 1 Replies | 1788 Views | Created by Sam233 - Thursday, August 30, 2012 3:43 PM | Last reply by Kent Waldrop - Thursday, August 30, 2012 4:21 PM

### converting Crystal formula to SSRS

Hi all, i have this Crystal formula below. I'd like to convert it to SSRS,but i can't convert it just like that because SSRS needs another "else ...
| 3 Replies | 4659 Views | Created by AddinGanteng - Thursday, February 28, 2008 7:27 AM | Last reply by LeighM - Thursday, February 28, 2008 10:11 AM