Excel Busn Math 29: Rate Of Change Formulas

Hi,

When I write the following in cell A1, =1&")", I get

1)

in cell A1.

What formula should I write in cell A2 so that I can get,

2)

in cell A2.

I tried the following in cell A2, =a1 + 1, but I get an error.

Can anyone help me find the correct formula.

I need an excel formula to calculate the negative nominal rate of return given the negative effective rate and the number of compounding periods per year. Excel's NOMINAL and NPER functions do not work when a negative rate assumption is used resulting in a #NUM! error. The context for this is that I am using MS Excel to to investment analysis. I want to analyse the resulting value of an investment account balance when there is a negative effective rate and corresponding nominal rate of return (mimicing a declining value in a particular investment/account due to negative annual return on investment expressed as a negative annual effective rate of return but that is compounding monthly - and hence the need for the nominal rate and compounding periods). I need to use a calcualtion in Excel that gives me the negative nominal rate of return equivalent to the negative effective rate of return assumtion.

Please help and thank you in advance if you can solve this!

I want to calculate the survival rate/failure rate for a product. Usually I use weibull distribution (linear regression followed by the 'WEIBULL' function), but unfortunately the data I have simply won't work with my current methods.

I have 10 different groups of widgets.
Group 1 widgets were installed 1 year ago. A certain percentage of those widgets are failed.
Group 2 widgets were installed 2 years ago. A certain percentage of those widgets are failed.
...
Group 10 widgets were installed 10 years ago. A certain percentage of those widgets are failed.

There are far fewer 10-year widgets than 1-year widgets out there.

The catch is that I don't know if the group 1 widgets will survive year 2, or if year 2 widgets will survive year 3, etc.

I want to create a nice curve that tells me (approximately) how many years the average widget in my sample dies 50% of the time. Unfortunately, there doesn't seem to be any ready-made formula in Excel for this. So I turn to you, brave Excel Board Members, to help me save myself from Math.

Please?

Right. So, here's what I need to do:

I'm developing a pretty specific pricing-related spreadsheet for work. One of the primary functions is to try and calculate a customer discount amount based on a total amount involving increments.

For example, my customer will get a discount of $5 for every $50 they spend. I'd like Excel to calculate that discount based on what my customer spends. If my customer spends $175, then Excel should calculate my customer's discount as $15 (there are 3 increments of $5 in $175).

I hope this makes sense to everyone. Is this even possible in Excel? Anyone? Thank you in advance for your help!!

Hi,
I need to put a mathmatical formula inside of a text box in Excel. Whenever I try to do it, nothing happens...the text box just displays the formula and doesn't actually calculate. Thx!

I've searched for about 4 hours now, so I finally have to break down and ask.

I'm creating an excel spreadsheet for physics (very fun) and thus far, doing it the hard way. For each equation, I've been using the =if(and(ifblank))) functions and rewriting my formulas for each scenario of blank or unknown cells. This has been a real PAIN IN THE REAR END!. Below is an example of what I have done (the hard way) with regard to right angles.

A1="Adjacent" B1="Opposite" C1="Hypotenuse" D1=Theta

A2=IF(AND(ISBLANK(A7),ISBLANK(B7)),COS(RADIANS(D7))*C7,IF(AND(ISBLANK(A7),ISBLANK(C7)),B7/TAN(RADIANS(D7)),IF(AND(ISBLANK(A7),ISBLANK(D7)),SQRT(C7^2-B7^2),"")))

B2=IF(AND(ISBLANK(B7),ISBLANK(D7)),SQRT(C7^2-A7^2),IF(AND(ISBLANK(B7),ISBLANK(A7)),SIN(RADIANS(D7))*C7,IF(AND(ISBLANK(B7),ISBLANK(C7)),TAN(RADIANS(D7))*A7,"")))

C2=IF(AND(ISBLANK(C7),ISBLANK(A7)),B7/SIN(RADIANS(D7)),IF(AND(ISBLANK(C7),ISBLANK(B7)),A7/COS(RADIANS(D7)),IF(AND(ISBLANK(C7),ISBLANK(D7)),SQRT(A7^2+B7^2),"")))

D2==IF(AND(ISBLANK(D7),ISBLANK(A7)),DEGREES(ASIN(B7/C7)),IF(AND(ISBLANK(D7),ISBLANK(B7)),DEGREES(ACOS(A7/C7)),IF(AND(ISBLANK(D7),ISBLANK(C7)),DEGREES(ATAN(B7/A7)),"")))


Now that I've tortured myself the hard way, I'm hoping someone can tell me how to simply write a formula that basically goes
=sqrt(A1^2 + B1^2 = C1^2)
Then automatically rearranges the equation so that if I have any combination of the two legs, it automatically solves for the other.

Thanks in advance for the help and reading this lenghthy post.

So I'm trying to combine two formulas that I can get to work independently. I don't know how much background you need since it's just a syntax issue so here's the basics and if you need more information, let me know.

1st: =IF(AC2>0,"8")
2nd: =M2-$F$1

This is used in a red/yellow/green due date format setup, F1 Contains the "=TODAY()" formula. M2 contains the Due Date. AC2 contains the "Received" date, which is why if it contains a date it should return an 8 (7 or less kicks in the Conditional Formatting, which isn't needed if it's received) since it would no longer be considered "due". Any help is greatly appreciated!

-Drew

Hello all. Thought I could find the answer to this in the forum and even tried the Internet, but my search terms either crashed the search function or the results were of little help.

I have 3 formulas I currently copy down on the sheet:

Code:

=MAX(0,E8-$B$5)

Code:

=(E8-D8)-K8

Code:

=(E8-D8)*F8

The code block I tried for the first formula is:

Code:

    'Formula insertion G
If Not Intersect(Cell, Range("E:E")) Is Nothing Then
    With Cell.Offset(, 2)
        .FormulaR1C1 = "=MAX(0,R1C1-$B$5)"
        .Value = .Value 'to override formula and leave just result
        .HorizontalAlignment = xlRight
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With
End If

I tried

Code:

.FormulaR1C1 = "=MAX(0,Cell-$B$5)"

as well as few other variations but to no avail. If someone can help with the above code block, I should be able to add 2 more code blocks for the other 2 formulas since they are all similar.

The above block checks to see if there is a date in column E. If there is a date in E, then the formula performs a simple subtraction of the date in

Code:

$B$5

from the date in column E and places the result in column G.

I didn't think it would be this difficult but I can't seem to grasp formulas written in VB.

Any help would be appreciated.

Thanks,
Andrew

Does anyone know the actual mathematical formula behind calculating a pament amount and interest rate behind these thwo excel formulas. I am trying to replicate this function in powerbuilder and need the formulas.

Hi there! I need a formula to calculate the negative nominal rate of return given the negative effective rate and the number of compounding periods per year . Excel's NOMINAL and NPER functions do not work when a negative rate assumption is used resulting in a #NUM! error. The context for this is that I am using MS Excel to to investment analysis. I want to analyse the resulting value of an investment account balance when there is a negative effective rate and corresponding nominal rate of return (mimicing a declining value in a particular investment/account due to negative annual return on investment expressed as a negative annual effective rate of return but that is compounding monthly - and hence the need for the nominal rate and compounding periods). I need to use a calcualtion in Excel that gives me the negative nominal rate of return equivalent to the negative effective rate of return assumtion.

Please help and thank you in advance if you can solve this!