Excel Busn Math 02: Formulas and Math Operators

I am looking for a way to find a number that is between two numbers. I know >=, and <=, but what about between two numbers. I can't figure out a formula that follows that formula. Help!

Hi all
how can i have math operators assigned to a button just like calculator so rather than pressing 1 + 1 i would like to have the operator buttons like on a calculator

thanks

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 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 wrong answers (based on the data that went into the graph to begin with.

The formulas excel gives me are these:

y = -1.1288x 3 + 23.209x 2 - 166.76x + 430.07 (preferred), or alternately


y = 579.38e -0.574x


So how can I enter this formula so that I can have it pull x from a cell and spit out the answer for y (and the reverse)?

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!

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!!

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

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.

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

I need a formula that does this. I have a base number of 300 seconds and want to add 30 seconds to it for every number over 1 so the output would be like this
input 0 and get 0 out
input 1 and get 300 out
input 2 and get 330 out
input 3 and get 360 out
input 4 and get 390 out
and so on. I can't for the life of me get the math down. Can someone please help.