Hi Everyone I am trying to achieve a cell that is dependent on two different cells. Basically what I want to do is: *Item 1* If the contents of Cell U20 equals the contents of W12 or W13 the cell will equal a certain value. *Item 2*Depending on the date that a task was set, the status will change. Item 1 is the priority. This is what I have tried so far, but still drawing a blank: =IF(U20=W13,"C",IF(U20=W12,"On Hold"))+IF(K20>TODAY(),"G",IF(K20=TODAY(),"A",IF(K20<TODAY(),"R"))) =IF(AND(U20=W13,"C",IF(U20=W12,"On Hold")),IF(K20>TODAY(),"G",IF(K20=TODAY(),"A",IF(K20<TODAY(),"R")))) Any help would be appreciated.

Member Avatar
Member Avatar
+0 forum 2

I'm creating a small and simple app to use with my poker league. I've created a small DB that I simply enter the player name, who took them out, and what place they went out in. All of that works just fine. What I need to do is implement the point system that I use so that the points column in the database is automatically populated with the players points based on when they went out of the tournament. I don't have my code with me on this computer, so I'll explain the process as best I can here. Heres …

Member Avatar
+0 forum 0

Hi I need help with something, I really don't know how to do this, but how would I add these questions in to VBA? could somebody tell me for atleast one. The net take-home income and other values are calculated as follows: 1) Calculate CPP and EI If annual income is greater than $48,600, then EI = $913.68 Otherwise EI = annual income * 1.88% If annual income is greater than $49,000, then CPP = $2425.50 Otherwise CPP = annual income * 4.95% 2) Calculate Federal Tax on taxable income (taxable income = annual income – CPP – EI)  …

Member Avatar
Member Avatar
+0 forum 2

how can i paste result from excel formula to value or even store the result into a string below codes does not seem to works... For x = 2 To rowcount worksheet2.Range("B" & x).Value = worksheet2.Range("D" & x).Text worksheet2.Range("C" & x).Value = worksheet2.Range("E" & x).Text Next worksheet2.Range("C" & x).Value = worksheet2.Range("E" & x).Text please help... XD

Member Avatar
Member Avatar
+0 forum 4

Good day, I am having troulbe with my computation here. i want to compute for the Custom_Haulage_In_Transit but when i exec my sp the value of the Custom_Haulage_In_Transit is 0. can anyone help me with this please.. here is my code SELECT distinct MATERIAL ,Description ,Material_Type -- ,Requested_Delivery_Date ,ATP_check ,Delivering_Plant ,Order_Quantity ,Held_by_Finance ,Rejected_OOS ,Rejected_Others ,Open_Order_Quantity ,case when Order_Quantity_NKA is null then '0' else Order_Quantity_NKA end as Order_Quantity_NKA ,case when Order_Quantity_RKA is null then '0' else Order_Quantity_RKA end as Order_Quantity_RKA ,case when Order_Quantity_Others is null then '0' else Order_Quantity_Others end as Order_Quantity_Others ,case when Stock is null then '0' else Stock …

Member Avatar
Member Avatar
+0 forum 3

Good day, I am having a probem with my sql. I want to create a formula for my pivot field.. here is my code... SELECT * FROM ( SELECT REPORT.MATERIAL ,REPORT.Description ,REPORT.Material_Type ,REPORT.ATP_check ,REPORT.Delivering_Plant ,REPORT.Order_Quantity ,REPORT.Held_by_Finance ,REPORT.Rejected_OOS ,REPORT.Rejected_Others ,REPORT.Open_Order_Quantity ,REPORT.Order_Quantity_NKA ,REPORT.Order_Quantity_RKA ,REPORT.Order_Quantity_Others ,REPORT.Stock ,REPORT.DSD_Delivery ,REPORT.OUtBound_Haulage ,REPORT.Total_OutBound_items ,REPORT.InBound_Haulage ,REPORT.Haulage_In_Transit ,REPORT.Process_Order ,REPORT.Total_Inbound_Items ,REPORT.Custom_Haulage_In_Transit ,REPORT.Custom_Inbound_Haulage ,REPORT.Custom_Process_Order ,REPORT.Custom_Total_Inbound ,REPORT.Custom_ATP_Quantity ,TYPES.* FROM CO09_Report REPORT INNER JOIN TBLTYPES TYPES ON REPORT.MATERIAL = SUBSTRING(TYPES.TXTMATERIAL,13,18) --WHERE REPORT.Custom_ATP_Quantity > 0 )AS T PIVOT (SUM(PERCENTAGE) FOR [TYPE] IN ([IN TRANSIT], [HAULAGE], [PRODUCTION])) AS pvt my problem is that how can i multiply REPORT.Haulage_In_Transit to [IN TRANSIT] that is located in …

Member Avatar
Member Avatar
+0 forum 2

Can anyone please explain to me how to compute DCT? I'm finding it hard to understand it. ![2D-DCT](/attachments/large/3/2D-DCT.png "2D-DCT") ![dct1](/attachments/small/3/dct1.png "align-right") I attached the formulas the Discrete Cosine Transform (DCT) and it's Inverse-DCT.

Member Avatar
Member Avatar
+0 forum 6

I have a site for youth basketball, where parents can list their kid to get them onto a team. The listings that get replied to by teams needing players are deleted, but some listing remain on there for months or years. To combat the potential confusion of which grade a kid is currently in, I have them list the kid's graduation year instead. Some parents, however, struggle mightely in figuring out the simple math in that. I want to put a textbox on top of the page that they can enter their kid's current grade, then have the output be …

Member Avatar
Member Avatar
+0 forum 8

Hi guys. First of all, I am aware that there is a somewhat similar thread over here. However, it was never really answered and the code given was obscure (I don't like copying stuff anyway) Either way... I want to balance a chemical equation. However, I don't need help on parsing a string or anything (which is what most other search results on Google turn up), because the compounds on either side are already separated into their constituent elements, as this is not a standalone app but part of a larger project I'm working on. I also know that I …

Member Avatar
Member Avatar
+0 forum 1

I will show you how to use EasyXLS, a .NET or Java library, as a calculation engine. EasyXLS supports all mathematical operators like arithmetic, logical and unary operators, and a various set of functions as Financial functions, Logical functions, Lookup and Reference functions, Database and List Management functions, Math and Trigonometry functions, Information functions, Statistical functions, Text functions or Date and Time Functions. You may find a full list of supported formulas on chapter Formula Support from this document: [www.easyxls.com/docs/EasyXLS_DetailedSpecificationsSheet.pdf](http://www.easyxls.com/docs/EasyXLS_DetailedSpecificationsSheet.pdf) EasyXLS uses a table to store data. You may fill the table with values and formulas that use those values. …

Member Avatar
+0 forum 0

hello i am trying to use selection formula with crystal report viewer i write the formula in string and set it to crystalReportViewer1.SelectionFormula here whe i use this formula " {Customer.LastYearSales} > 11000"; it said a string is required here & when i change it to this " {Customer.LastYearSales} > \"11000\""; it said a number is required here please help me with the above errors

Member Avatar
+0 forum 0

hello i am trying to use selection formula with crystal report viewer i write the formula in string and set it to crystalReportViewer1.SelectionFormula here whe i use this formula " {Customer.LastYearSales} > 11000"; it said a string is required here & when i change it to this " {Customer.LastYearSales} > \"11000\""; it said a number is required here please help me with the above errors

Member Avatar
+0 forum 0

i have this code where it computes for the time entered by the user. it doesn't have yet the limitations or the conditions regarding the time to be entered . it successfully computes for the time and the hour increases based on the minutes, but the problem is when you entered "9" for the hour it doesn't add to the total but the rest is fine.. anyone can help ? so here it is: <html> <FORM> <table name="tblSamp" border="1"> <tr><th>Time</th> <td><input type="text" name="alpha" value="" onchange="addColon(this.form.alpha, this.form.total);" maxlength="5"/></td> <td><input type="text" name="beta" value="" onchange="addColon(this.form.beta, this.form.total);" maxlength="5" /></td> <td><input type="text" name="gamma" value="" onchange="addColon(this.form.gamma, …

Member Avatar
Member Avatar
+0 forum 6

So my code is suppose to get information from the user and figure out how much funding the two professors get. My code runs twice but for some reason only the last entry is saved and outputted and my formula for calculating the new funding only outputs zero for some reason here is a sample of an output. Name: Steve Position: Assitant Professor Institute: UCLA Number of Papers Published: 11 Past Funding: $200,001.00 75 0.0 Heres the two classes [CODE]import javax.swing.JOptionPane; public class NSFFunding { /** * @param args */ public static void main(String[] args) { Scientist scientist = new …

Member Avatar
Member Avatar
+0 forum 5

MY problem is related to entry of research data. The researchformula is entered into a textbox alongwith other usual form entries like title,subject,startdate etc. The formula consists of alzebra, trignometric, otherfunctions etc. Example [CODE] [B]x = 12; y = 24 + tit[x] + mixer[x]; z = x + sin(x) + tan(x+y) - max[x,y]; #final result is 24.778273666352;[/B][/CODE] The program is not concerned with the syntax or result of these formulas. The form must however display some details of the formula in the following format in textbox on buttonclick a) variableused name and characterlocation of variables like x(1,19) y(8,) since x …

Member Avatar
Member Avatar
+0 forum 9

Good morning everyone, I have a small problem here. I tried to code a piece of program which allows users to construct logic formula. (E.g A V NOT(B)) When the button NOT (unary connective) is pressed 2 times then this happens: [COLOR="Green"]NOT(NOT())[/COLOR], using a static recursive method called Rec returning the string and has 2 following parameters: --> int counter : the number of time the button has been clicked --> string strConnective: the name of the button pressed(E.g NOT). But the problem is when another button than NOT is pressed (E.g[path]<F>) which is also an unary connective, the output …

Member Avatar
+0 forum 0

Hello Members, Would anyone please take a look at my attached excel files which is a commodity exchange's end of the day data file. This is a free copy which anyone can download from their websites. Those are ([url]www.mcxindia.com[/url]) & ([url]www.ncdex.com[/url]). Now my query is in those two files there is a column named "Expiry Date". Now, how can I change that Month to I,II,III... with their respective names, like whichever is the nearest month including current month in GOLD or any commodity name will named like GOLD-I,GOLD-II.. so on. I try this with Excel's find and Replace function, like …

Member Avatar
Member Avatar
+0 forum 1

I've searched a while, can't find this... I'm looking for a way to present two choices for values, then to have a result immediately appear based on those choice. IE... The first choice is an option between 1, 2, 3, 4, or 5 players... and the second choice is an option between 1, 5, 10, 25, or 50 workouts. In the following textarea (or whatever) I'd like a price or a set of prices [B][COLOR="Red"](based on the combinations, not a math formula)[/COLOR][/B] to appear as the choices are made and again when they're toggled. [B]Here's my start. Any help will …

Member Avatar
Member Avatar
+0 forum 17

The End.