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(K20TODAY(),"G",IF(K20=TODAY(),"A",IF(K20 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 … +0 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. +0 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 … +0 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 … +0 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. … +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 +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 +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:
Time 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]) which is also an unary connective, the output … +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 … +0 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 … +0

The End.