math

At the most basic, I am trying to find the return value of two subtracted numbers pulled from the assigned value of two different text strings. Last week, I understood what Functions are, and that Subs do not return a value, and I am still learning how to use functions, and would appreciate...

Hi Guys, Have the following line of code that I would like to add 1 to the result of. Cells(Target.Row, "F") = Cells(Target.Row, "E") - Cells(Target.Row, "D") I've tried a number of ways to get this to work with no luck. Any thought's would be great. It forms part of the following code that I...

I need to take the number below and divide it by several numbers, (a different number to divide by each row). 2891966705430700585 I want to know whether there is any sort of add-in for excel that will let me do math with numbers larger than 15 digits.

I have been pulling my hair out trying to enter this equation and have no idea how to get this to work properly or what is the right format to get the answer out of Excel. 365 COS (130)

A1---------- A2------------- A3 Postcode--- County-------- Country <table style="width: 342px; height: 49px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" width="64"> <col...

I have a hard formula that i want to construct in excel and i need help... I have made up an equation in one cell (A1) that is the average of 4 other cells. What I need, is this answer (A1) to then equal a "Pass" in another cell dependng on the if the answer in A1 is between values x (cell B1)...

I need a formula to find the percentage of savings in a specific range of cells. So far i have this, but I keep getting a value error. =SUM((W19:W28)-(X19:X28))/(W19:W28)x100 Then i need the total of that equation diveded by this range (W19:W28) which should give me the percentage. But I...

Hi guys I need help finding out which formula works best at find similarities between to rows. For example Row A1................... Row B2 8443..................... 1231 1554...

Here is my fun :) I have a formula that does =SUM(SUMIF(A3,"TEST",B3),C2) Now what I want to do is replace the "C2" with a more dynamic value and get the value of the the last row above current cell that has data. My reasoning is becuase each of these rows is ordered by a date field and...

I have the following script for calculation of one textbox plus another textbox, can someone please provide a script that I would use to calculate a percentage, i.e. 100 - 60% (answer 40). I want this to be a textbox calculation within userform, I don't want to copy values to cells...

I thought this would be easy, but is proving to be difficult at least for me. I am using the CONCATENATE function to string together names and employee ID's. Both fields are variable length and I would like the ID's to follow the names, but all lined up so easily readable. I thought I could...

I have created a graphed curve in excel based on data I have entered. I now want to take the formula for the graph, and use it as an excel computation where I can plug in X and get Y, or plug in Y to get X. However, when i try to enter in variations of these equations, I end up with just the...

I'm trying to get all of the possible combinations of 3 that cost less than $4 and their values in a list using an excell formula? Is it possible? There are 7 things at the store and you must buy 3 different ones without spending more than $4. All 7 items are valued differently than their...

I created a simple table with reimbursement rates and amounts. The amounts have no order and should not add to 100% as this is not a cumulative type thing. Basically, I have people that were reimbursed at different levels. I calculated the percentage for each person based on how much they...

Does anybody have/know where to find a list of the math functions that VBA has? I know a couple already such as Sin() and Cos() but would like a comprehensive list. I'm using Excel 2003 and do not have the option to install additional libraries. Thanks a lot. Johhny.

I have four columns that i need to have the user decide the simple mathematical relationship between them using a drop down menu. Ex. a1+ a3+a4*a5=a7 with the math signs on a drop down list. Then be able to have blanks if needed. The blanks i figured out seperate by using an if statement...

I have a question regarding the excel trend line and he equation it provides. I have a temperature vs viscosity graph and I have added a eponential trend loine and displayed the equation. I have used that equation to calculate actual readings vs where they should fall on my graph. The...