1. S

    Search named ranges for matching cell contents

    Hi all and thanks for all and any help. I have one workbook with two worksheets. I have a list of references on the first worksheet and a HUGE list of references on the second worksheet but they are grouped into two named ranges. I would like to write an equation where the reference in...
  2. FracinDean

    Controlling Fonts When Using Excel Equations for Strings

    How can the font or bold/italics/underline of only certain parts of a string equation result be changed when using equations? An example of what I would like to be able to do below: ="This is step number "&text($a$1,###)&" of "&text($B$1,###)&"." But I would like to be able to change the...
  3. K

    Text equations wil not evaluate

    I have equations including text, providing information on source directory & save directors the VBA processes. In some cells, they evaluate. For example: In cell B3, ="J:\ACCOUNTS\Credit Cards" & B15 & "" evaluated to J:\ACCOUNTS\Credit Cards\2018\ In cell B4, ="J:\accounts\Xero\Credit...
  4. J

    Time and Duration

    First, a Disclaimer. I am absolutely 100% new to working with Excel. This exercise I am having an issue with is my first time playing with cell formatting and formulas. What I want to do, which sounds simple in my head, is input an amount of time into a cell, but have it display as its decimal...
  5. S

    Data Validation for Equations in a Table

    Hello, I am looking for some assistance. I have a table that auto-populates from a second table using equations once the first cell is populated. However people are going in and pasting over the equations and I was hoping to use data validation to prevent this from happening. I cannot protect...
  6. U

    Mass conversion of equations to excel formulas

    I deal with equations that are drafted in microsoft word that look like this: (1.0 x 0.03125 x 0.20 x 187.4237/1920.00) If I independently put an = sign in front of (1.0 it will turn it into a formula after asking to correct for typo for x to become * The problem is I have hundreds of these...
  7. C

    Summing a product with selection Criteria

    I'm trying to make a table that will sum a the product of a value and probability based on a criteria value in another column. The table below is an example of what I'm trying to do: <tbody> Criteria Prob 2019 2020 2021 2022 X 100% 41 10 75 150 X 90% 24 24 24 Y 65% 53 160 X 70% 25...
  8. R

    Merging Columns, Need help on the Right Equation

    Hi Everyone, I am having trouble with an excel project in which I have two columns that I feel could be merged into one. I have designed a database that keeps track of adjectives used to describe dog toys by men and women. I first track the gender of the dog, then the gender of the toy is the...
  9. E

    An Equation

    Hi, I think this is impossible but I will take a chance because if it is possible it will save us lot of work and time. At work I have a CAD software and I use equations to set X, Y, Z positions and material width, length and height. Equations are similar to Excel formulas. So if it works in...
  10. L

    Linking sheets with equations

    Hi I am reading excel course outline and I read the following: Linking sheets with equations Linking files with equations What does that mean? how to link sheet/file with an equation? Thank you so much. Course outline is here http://www.ctccomputertraining.com/excel2010trainingcourses2.html
  11. M

    SUBSTITUTE Function - 3 Digit Problem, Only Checks First 2 Digits.

    Hello, I'm using substitute nested many times to turn formulas with cell references into equations with text. It's a multipart process starting with a formula-to-text function generating a secondary array, some other stuff, and then a huge string of nested substitute functions generating a...
  12. A

    Extracting Characters from Cell

    Hi In column c I have a number of equations such as 2x + 20 . I need to pull out the 20 into another adjacent cell. I used: =right(c1,len(c1)-Find(" + ",c1)) and it gives me the 20 . The problem is that some of the equations have a negative in them ex. 4x - 19 or 2x - 6...and the formula above...
  13. S

    Trendline Equations - Can't Get *Future* Values from 3rd Order Polynomial

    Hi All, For several years now I've used the formulas from this page: http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/ ..to great success with easier equations like Linear & Power. However I've now tried 3rd order polynomial and I've run into a distinct problem. I can get...
  14. K

    Use a variable inside an equation that is entered with VBA

    I have a loop that reads through worksheets in a workbook and creates equations in specific cells to parse data. The problem is that one of my equations does a lookup in a named range in another sheet and I need to be able to place a variable in the equation so that it will paste the correct...
  15. B

    Nesting IF statements

    I have tried a few combinations but cannot get the end state I am trying to combine these two equations. I've tried using IF(AND(OR without luck. Again thanks for the help! =IF(AND(D2="10k",E2<=120),"Go,"No Go") =IF(AND(D2="20k",E2<=240),"Go,"No Go")
  16. A

    Extracting the first and second coefficient from equations

    I am using =(left(C1,1)=”x”,1,0+(LEFT(C1,Find(“x”,C1)-1)) to extract the first coefficient from formulas. This works for the first and second equations but not the third. - 9x - 9y = 54 yields -9 x + y = -4 yields 1 - x - 7y = -33 yields #value How can I adjust that to...
  17. T

    **Simplified: Excel Work Week Hours sheet Question. Need formula help please!

    Ok, this is a challenge! for simplicity I'll list only pertinent data needed. Say I have 7 rows (1 row for each day of wk and 8 columns in a time sheet: G-total hrs worked (that day), H-billable hours(of that days total), I-Shop hours (non-billable hrs worked of that days total), J-Running total...
  18. Q

    "Yes" or "No" Nested IF Statement with Specified Date

    Here is what I am trying to do: =IF(AA5="","No",IF(AA5<=J5,"Yes","No")) - My lame attempt Upload Days = AA5 (The number of days to acutally complete the project) SLA Days = J5 (The number of days allowed to complete a project) Project Uploaded Date = M5 (The date that the project was...
  19. Q

    Nested IF Statements

    Here is my equation: =IF((M5="","",IF((NETWORKDAYS.INTL(X5,M5,11,______!$O$4:$O$17))<1),"1",IF((NETWORKDAYS.INTL(X5,M5,11,______!$O$4:$O$17))>=1),(NETWORKDAYS.INTL(X5,M5,11,______!$O$4:$O$17),"False"))) What I am trying to do is as follows: - If Cell M5 is Blank, display "Blank" its an empty...
  20. Whylucky

    Macro Not Solving For Fractions

    Hey Everybody, So i have a unique problem, I'm using a find code to extract text and separate it out to individual cells. Then a macro solves an equation based on the extracted values. The problem is when i use fractions the macro will not solve, i attached a link to share the file. Any help...

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