Excel Basics #5: Formulas Operators and Math

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.

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

My dear friends & respected ones,
warm regards to everybody.

I am new to this forum. My query is :Is there any operator or function in MS Excel to reverse the bit pattern of a binary no. as we perform in Boolean mathematics.

Eg. Suppose there is any binary no. in cell A5 as "111011110101", so by using any operator, how inverted binary no. i.e. "000100001010" can be obtained.

Also are there other operators so as to perform AND, OR, EX-OR operations of digital electronics?


Best Regards,
-------------
Aashu