math formula

  1. R

    Help converting math notation to Excel formula

    I am trying to recreate a mathematical formula below in Excel. I cannot get it work and am hoping a second set of eyes my helf I have pasted an image of the actual formula and written it out below with its answer. = 1.1494 ∗ 10^−3 * ( 288.7 /101 ) * [ (7000^2 − 𝑒^0.0016 2800^2 )/(0.0696 ∗...
  2. B

    Problem translating math into excel formula (correct picture)

    Hi, I have a problem translating this excel formula (actually the combination of two) into excel spreadsheet. Probably I do something wrong regarding the syntaxis for the natural log (ln()), as my math skills are a bit rusty... Does anybody have a clue how the excel-formula would look like...
  3. J

    Average issue or my lack of understanding math?

    <tbody> hours complete avg hr 1 85.5 204 2.39 2 133 90 0.68 3 175.25 294 1.68 why are these averages different? 4 131.5 383 2.91 which one is the true average? 5 125 469 3.75 6 143.5 592 4.13 total 793.75 2032 2.59 or 2032 dived by 794 equals...
  4. B

    Reverse Excel formula please

    I have a formula that I want to reverse, as follows: Cell A1 = 7 Cell A2 = 4* Cell A3 = £150 Cell A4 = 100 Cell A5 = 50 Cell A6 = 5% *Note: Cell A2 is a function of Cell A1, which is an average (i.e. (7+6+5+4+3+2+1)/7); so for example if Cell A1 = 6, then cell A2 would be (6+5+4+3+2+1)/6 = 3.5...
  5. C

    Math formula translation to Excel formula

    Good afternoon all Can anybody please help me translate the formula below into Excel speak: Answer = 10 log[10^(X1/10)+10^(X2/10)+10^(X3/10)] Where X1, X2 & X3 are my data entry points. I have tried it as the following but the answer is not what I expect...
  6. G

    Using math-formulas like a TI84-calculator

    For a blind student I'm making a excel-sheet working like a graphics-calculator table. In Cel C10 I want to put the math-function using an "X". In column A18 thru A38 there are some values for "X" Then I want to display in column B18 thru B38 the calculated answers ... using the value for "X"...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top