No announcements
Found 2823634 threads
-
4 VotesExcel-like formulas for business properties
You can cobble something like this together for yourself, using interdependent variables (if formula var value is nothing then return text, else change text to ...Answered | 8 Replies | 3151 Views | Created by Tekito - Tuesday, February 1, 2011 5:24 PM | Last reply by Corey Furman - Monday, February 7, 2011 3:17 PM
-
1 Votes
Write Excel formula in XML and load it dynamically
You may store the formula where ever you want.Answered | 3 Replies | 1371 Views | Created by tBStar - Saturday, May 18, 2013 5:33 PM | Last reply by tBStar - Tuesday, October 8, 2013 1:11 PM -
0 Votes
Dynamic Formula
This is what you want: http://www.ozgrid.com/Excel/DynamicRanges.htm It may take a bit getting used to (hopefully not).Answered | 2 Replies | 4484 Views | Created by AgimM - Tuesday, November 23, 2010 9:17 PM | Last reply by Scott Gall - Thursday, December 2, 2010 6:01 PM -
0 Votes
excel formula
Are you want to use formula in excel or SharePoint list?Answered | 2 Replies | 1241 Views | Created by cindy127 - Friday, March 25, 2016 7:25 PM | Last reply by Lisa Chen1226 - Monday, March 28, 2016 10:44 AM -
0 Votes
Excel Formula
Use it on a blank Excel file, so that you understand how it works, and then use it on your main file.Answered | 2 Replies | 1511 Views | Created by Maggiejt - Sunday, May 28, 2017 3:04 AM | Last reply by Vijaykumar Shetye - Monday, May 29, 2017 4:52 AM -
0 Votes
Add the formula to the formula bar in excel
Hi Helix, According to your description, you want to see the expression in the excel file after exporting to excel, right?Answered | 3 Replies | 1220 Views | Created by Helixpoint - Tuesday, September 1, 2015 5:41 PM | Last reply by 王者荣耀 - Wednesday, September 2, 2015 2:38 AM -
0 Votes
Looking for R code that is the equivelant of an Excel formula
I can make it work in Excel, but I am trying to do all the data prep steps in Azure ML/R.Answered | 5 Replies | 411 Views | Created by Priya Santhanam - Tuesday, December 6, 2016 11:02 PM | Last reply by jopela-msft - Friday, December 9, 2016 4:36 PM -
1 Votes
Excel Formulas in SSRS 2008
If you use Field name or any codes using Fields, when exported to Excel Formula's wont be there..Answered | 11 Replies | 21652 Views | Created by Simon Ringuet - Tuesday, July 20, 2010 5:50 PM | Last reply by LuisNY - Friday, May 1, 2015 6:53 PM -
0 Votes
Dynamic Analysis Code Like Excel Formula
User-47589850 posted Hi YihuiSun, Is it too much code for a single formula?Unanswered | 4 Replies | 106 Views | Created by Anonymous - Saturday, June 27, 2020 1:06 PM | Last reply by Anonymous - Wednesday, July 1, 2020 9:01 PM -
0 Votes
Hook into Excel formula mechanism
The Range object has a Formula property which you can set like this: textBox.Text = ...Answered | 1 Replies | 4962 Views | Created by Adam Cataldo - Saturday, April 25, 2009 12:20 AM | Last reply by Jose Anton Bautista - Monday, April 27, 2009 4:36 PM -
2 Votes
Is FxCop a static analysis tool or a dynamic analysis tool
The VS-integrated "Code Analysis" tool adds several rules beyond those available in the free, stand-alone version.Answered | 4 Replies | 4645 Views | Created by watzr - Monday, April 23, 2012 3:50 PM | Last reply by Nicole Calinoiu - Tuesday, April 24, 2012 6:25 PM -
0 Votes
Analysis Features Within PowerPovit add-in for Excel
Hi LAWSQL, It sounds like you need Data Mining :) Check out the Excel data mining add-in.Answered | 4 Replies | 5630 Views | Created by LAWSQL - Thursday, February 10, 2011 7:45 PM | Last reply by Tatyana Yakushev - Monday, February 14, 2011 6:32 PM -
0 Votes
Problem with convert an Excel formula to a PowerPivot formula
And in PowerPivot, you work with tables and columns instead of actual cell references in excel.Answered | 1 Replies | 4512 Views | Created by XeonCore - Thursday, November 22, 2012 12:12 PM | Last reply by Brent Greenwood - Thursday, November 22, 2012 2:30 PM -
0 Votes
Converting Excel Formula to VBA code
Hi NYYFAN, For IF and OR function: If Range(“C8”).Value=”Work” Or Range(“C8”).Value=”Off” ...Answered | 1 Replies | 808 Views | Created by NYYFAN_NC - Wednesday, November 19, 2014 1:55 AM | Last reply by Starian chen - Thursday, November 20, 2014 9:28 AM -
0 Votes
How to optimize this complex excel formula ?
Balaramji, After changing “And, Or “ your formula only have some few functions like weekday, max and choose.Answered | 1 Replies | 713 Views | Created by Balaramji - Wednesday, May 4, 2016 5:29 PM | Last reply by Deepak Saradkumar Panchal - Thursday, May 5, 2016 6:12 AM -
0 Votes
Excel Formulas in Sharepoint
error appears when the formula that contains the function refers to cells in a closed workbook or the cell are calculated.Answered | 4 Replies | 7702 Views | Created by torystcyr - Tuesday, December 1, 2015 4:05 PM | Last reply by taylor.l - Wednesday, December 2, 2015 12:26 PM -
0 Votes
Excel formula
I believe you should ask your question in a Microsoft Answers/Community forum dedicated to Excel, such as this ...Answered | 1 Replies | 1305 Views | Created by mexximigo - Wednesday, May 24, 2017 6:06 AM | Last reply by Richard Mueller - Wednesday, May 24, 2017 8:11 PM -
0 Votes
excel destination data with formula in ssis
Instead, create an Excel file with the formulas in it already, and just dump raw data into the existing file.Answered | 6 Replies | 10951 Views | Created by md afzal - Thursday, March 8, 2012 7:02 AM | Last reply by waqaramin - Wednesday, April 25, 2012 12:31 PM -
0 Votes
Excel Hierarchy Formula
If it was column D, the formulas to enter (and fill down) would be: Cell ...Answered | 4 Replies | 1017 Views | Created by kvc2 - Tuesday, November 19, 2013 2:00 PM | Last reply by iambasil - Tuesday, November 19, 2013 4:14 PM -
0 Votes
excel if then formula/macro
I need a simplified if/then formula.Answered | 1 Replies | 2558 Views | Created by chilimichigan - Wednesday, October 19, 2011 4:53 PM | Last reply by Tushar Mehta - Wednesday, October 19, 2011 5:25 PM - Items 1 to 20 of 2823634 Next ›
No announcements
