I cant get this formula to work correctly in the target cell. What is wrong with my formula notation? 
Category : Development Tools & Services 
I cant get this formula to work correctly in the target cell. What is
wrong with my formula notation? The offending formula, which im
trying to generate using the code below, should look like this
=importRange("0AkVkE5M2c","clan members!A1:D172") in
the target cell. but it does not var source =
SpreadsheetApp.getActiveSpreadsheet(); var
View Replies



Create formula on excel column that all ready have a formula on it 
Category : Programming Languages 
I am using Excel 2010. I have field A1 and A2. Field A3 have the following formula =CONCATENATE(A1,A2)
Now I want to place a
formula on A1 and A2 to make the field background RED with a formula if the
Value is not equal to "000". But I cant add a formula to A1 or
A2 now because I am making use of it in field A3.
View Replies


If or conditional formula formula in Google apps script 
Category : Development Tools & Services 
I am trying to put conditional formula in spreadsheet using google apps
script but i am not getting the way out to resolve this. The
VBA equivalent to the required GAS is: Sub ageing()
Rem Ageing Slabs for ADVANCES With
Range("ap2:ap4000") .Formula =
"=IF(u2="""","""",if(u2<0,""Delivery Reported a
View Replies



Malformed VLookup formula when trying to use Range.Formula property 
Category : Programming Languages 
I have Excel sheets that will have data from many sources that will be
grouped together so that what needs to be looked upon is above what you are
looking from so there will be many VLookups on separate portions of one
sheet. Sub linkFDCfdv() Range("A1").Select Dim
doesFDChaveDescription As Boolean Dim isLastRowFDC As Boolean Dim
myRange As String Dim fir
View Replies


Adding formula to Excel with C#  making the formula shown 
Category : C & C++ & C# 
I wanted to add formulas to an Excel workSheet. I managed to do so
with the Formula property. The problem is that when I open the
worksheet in Excel, I can see that the formula works  but I can only see
the result in the cell. I can't see the formula that was calculated in the
Formula Bar at the top of Excel. Obviously if I enter a formula
in Excel itself I can see t
View Replies


How to use org.apache.poi.ss.formula.FormulaParser to parse the formula? 
Category : Development Tools & Services 
Can u give me the simple code snippt using
org.apache.poi.ss.formula.FormulaParser. FormulaParser class
having the method parse().But it returns ptg[].i dont know where is the ptg
class...
Please guide me to use formulaParse to parse the excel
sheet formula... Saravanan
View Replies


How to pass the righthand side of a formula to another formula? 
Category : Programming Languages 
I would like to pass the righthand side of a formula to an R function
which then "adds" the lefthand side of the formula and calls
gam() . I would like to achieve this without ugly as.formula()
constructions etc. I got stuck in the following minimal
example, do you know what went wrong? require(mgcv) set.seed(0) ## set.seed(1) gamEx1 < gam
View Replies


Change Formula Value through another Formula in Crystal Report 
Category : Programming Languages 
I want to change a value of a formula through another formula in Crystal
Reports. I have a problem: i have a string column in DB and
is saved for example "Cars" or "Doors" or .. and on the report
i have all the categories written in Normal Textboxes. (Like a
RadioButtonList). and want if the Column is "cars" it will
check next to the cars TextBox. (Like a R
View Replies


Converting string formula to mathematical formula in c# 
Category : C & C++ & C# 
I am doing c#.NET application to calculate different formulas and give
result to user,users can enter any formula and each formula values are
stored in database like this. After saving like
this i want to calculate the result.When calculating the result,application
ask values for variables .But how can i calculate with this
values. Please help to retri
View Replies


How do I replace the formula in a cell with the output of the formula? 
Category : Programming Languages 
How do I replace the formula in a cell with the output of the formula?
I simply need "=RIGHT(E86,LEN(E86)+1FIND("(",E86,1))" to
become "(e)" Is there a way to do this to the whole sheet?
Replace all the cells with formulas with the text they are displaying? I am
using version 2003.
View Replies


