equations

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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")

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

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

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

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

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