# formula

• ## Errors when nesting IF() formulas2018-10-11

I'm just putting together a simple spreadsheet that calculates tax owed based on a few different bands. I have an 'Invoiced Amount' cell that takes up the yearly invoicing and then applies a tax rate to it based on the following conditions: If 'Invoi

Tags: excel, formula, nesting
• ## Match Data from Two Excel Files that Share Similar Attributes2017-12-07

I have two different Excel spreadsheets. They have almost the same data, but it has been updated so some entries are not there anymore or some items have been added. I feel that this shouldn't be too difficult, but I cannot figure it out. I have atta

• ## Catching iterations using php modulus in an irregular sequence2015-01-26

How can I write a modulus that will select the following iterations in sequence? 1, 4, 5, 8, 9, 12, 13 etc (+3+1r) I'm working within a loop and counting posts (iterations). So for example, I could catch every third post (1, 4, 7, 10) by:- if (\$i % 3

Tags: php, formula, modulus
• ## write out formula with paste2015-01-11

there is a vector (called f) f 3 4 8 it indicates which columns from a dataframe (y) should be included in a model. The column names of these columns are FER7, TOJ9, GHY11. Can somebody tell me how I could achieve that response~factor(FER7)+factor(TO

Tags: formula, paste
• ## Adjusting Binary Logistic Formula in SPSS2014-12-11

I am running a binary logistic regression in SPSS, to test the effect of e.g. TV advertisements on the probability of a consumer to buy a product. My problem is that with the formula of binary logistic regression: P=1/(1+e^(-(a+b*Adv)) ) the maximum

Tags: binary, regression, control, formula, spss
• ## Excel: Index Match using wild card to match search criteria against all text in a cell?2014-12-04

I am using the following Index match code with row function to avoid returning duplicates in my results. The formula currently search's my column B on my sheet 'Look Up Supplier Sheet' where it compares the value entered in cell D11 on sheet 1 and pr

Tags: excel, lookup, formula
• ## replenishment formula oracle sql query2014-12-04

I have a table with the following structure: Item Code item Description Minimum Quantity Maximum Quantity Reorder Quantity Current Stock in Location Current Stock in Main Location Replenishment Quantity I would like to calculate the replenishment qua

Tags: sql, oracle, formula
• ## Excel: Returning characters to the left and right of the last (or second to last) occurrence?2014-11-02

I have a string like this: 100 Stupid Street ; Government Tower 7; Chicago Palm, MA 92111 I want to return all the characters to the left of the last semicolon. So, To the left of the last semicolon would be: 100 Stupid Street ; Government Tower 7 Th

Tags: string, excel, return, formula, semicolon
• ## Using square of a variable in R Formulas2014-08-05

I'm trying to run a regression including the square of the independent variable. Other transformations seem to work, but the square isn't recognized. eg lm(y ~ x + x^2 + sin(x), data=as.data.frame(cbind(x=rnorm(10), y=rnorm(10)))) Call: lm(formula =

Tags: formula
• ## Spreadsheetlight Formula not working2014-05-07

i'm using Spreadsheetlight for creating excel document. I need to use a formula on a specific cell, but it's not working. The code: report.SetCellValue(string.Format("{0}{1}", Report.CELL_MAP.ACTIVITY_CRU_COL, row), string.Format("=IF({0}{1}=0; 0; RO

• ## Countif with selection to the last non-empty cell in a column2014-04-29

My rng1 only contains non-empty cells to the last cell in column A. I want to count cells greater than the value in B1 in rng1. However, this formula didn't work and showed error was due to empty cells. Sub CountRng1() Dim rng1 As Range Set rng1 = Ra

Tags: vba, formula
• ## Conditional formatting on all duplicates2014-03-12

I'm trying to make a formatting rule in Business Intelligence/Web Intelligence that changes background color of all duplicates based on one field (address id). The best I've got so far is this: =Previous([Address Id])=[Address Id] But that code only

• ## EXCEL: How do I count a pattern of values across multiple cells?2014-01-07

I have an attendance spreadsheet with values "OFF", "VAC", "HOL" and "SCK". I am trying to identify abuse of the SICK day policy where employees use their SICK days to extend their weekends, vacation or holidays. I would like to count the number of t

Tags: excel, formula, count, cell
• ## How to count if value = one of multiple values?2013-12-22

I'm trying to figure out how to countif a range = one of multiple values using LibreOffice / OpenOffice Calc. So it would be where it counted if the value = one in a range of values (E.g B1:B20 contains all the values that would be acceptable for it

• ## Copy the Field value from one Form to other Form by @formula-LOTUS NOTES2013-11-06

I want to Copy the Field value from one Form to other Form by @formula, How can it do it. Main Form name is "A", second Form name is "B", Form "A" Field include[ID/Name/AEmail],Form "B"Field include[ID/DateTime/Record/BEamil] When create a new record

Tags: forms, lotus, formula
• ## Syntax of Mathemathical formula in Python2013-10-29

I am trying to implement a mathematical formula in Python and I am quite the beginner at this so please work with me. I have two 3-column tab-separated files: For example: inputA: abandonment-n about-bring-v 32.5890 abandonment-n about-complaint-n 5.

Tags: python, syntax, formula
• ## Converting Pixels to LatLng Coordinates2013-10-25

Hello Programming World, I am using the Google Maps API v3 and I have a map overlay that I need specific coordinates from. In the image, I've managed to convert the two pixel coordinate sets from the top left and bottom right into latitude and longit

• ## Selecting rows based on cell value2013-08-01

I have setup a pivot table to display some data. In a separate sheet, I would like to show all of the rows in that table based on the value of a cell within the table row. I would like to do this using formulas, but really have no idea how to go abou

• ## copying Excel rows to sheets if date time cell falls between 0000 & 0600?2013-07-11

How would I copy Excel rows to a new worksheet if a date time cell falls between 0000 & 0600 ? For example, for 10,000+ rows of data, in Column J, there's a date/time stamp "1/15/2013 0245". How do I create a formula which looks at the last 4 dig

Tags: string, excel, copy, find, formula
• ## What does a formula with no left argument mean in R, e.g. ~x?2013-05-10

I understand that in a formula like y ~ x I am looking at "y" as a function of "x". In maths this would be something like f(x) = x. In R, functions like xtabs can take formula objects without a left side, e.g. xtabs( ~ x). From my understanding of fo

Tags: formula

Copyright (C) dskims.com, All Rights Reserved.

processed in 3.318 (s). 9 q(s)