Excel Busn Math 40: Equivalent Earning Formulas: 12 Examples

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.

Hello,

1. Is there any document, that Contains Examples of Each Function and Each Formula in Excel.

2. I saw some person using find and replace option in word with "$" and "#" for removing Characters and Numbers. What my Question is, Is there any other Procedure and tips like the above.

Thanking you in advance.
Waiting for your Kind Reply.

does anyone can help me in this issues?
I just read the MS Training but i didn't get it.
Will be better if you can help me with examples and more simple explanations

******** ******************** ************************************************************************> Microsoft Excel - Book1 ___Running: 12.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout A2 =
A B C D 2 Percent 25% 5% 15% 3         4 Desired Result 0 10000 5000 Sheet1  
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

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

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

help

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