# equation

1. ### Excel equation for dates past a certain date

Help please if you can, I cant seem to find anywhere else. Im trying to find the equation for 2 things, 1. I have a chart I'm making and trying to calculate if something is past due 30 days, 10days, and 5 days is there an equation to find out if the dates I entered have passed...
2. ### Multiple equations and multiple variables

The following post will be long and I'll probably make a fool of myself explaining the rut I'm stuck in, but bear with me. It's based on analytical chemistry calculations, if that's worth anything. I have a mathematically solvable system of equations, but it relies on multiple variables that...
3. ### Raising or discounting the price of inventory against a curve that represents the average temperature in a certain area.

Hi all. Firstly im new here and English isnt my native tongue so I would like to apologize beforehand if my explanations aren't very clear. Truly appreciate if anyone can help me with the following: I generally have two sets of data: 1.First one is an inventory list of clothes with their...
4. ### Evaluate math formula from Equation editor into cell

Hello MrExcel community, this is my first post, so if there is anything about this post that isn't posted correctly feel free to tell. OK so going into the main thing, In my Excel sheets I use plenty of long and complex mathematical equations, that when trying to replicate form paper into...
5. ### Using Excel solver (or other method) with a common objective in multiple cells by changing the same variables, subject to constraints

Hi, I am struggling with quite a complex problem in which I think I may be able to solve or at least partially solve using the Excel solver tool. I am trying to set up a design of experiments analysis in which I have a number of parameters at two levels. I have one specific objective which I...
6. ### How to Convert an Exponential Trendline Equation to a Formula

My data is in 2 columns. Column A is my Y axis, Column B is my X axis. I have maybe 30 rows of data, and I created a line with markers graph using that data. Then I right clicked on the data line to have Excel create a Trendline using Exponential. I then clicked the option to show the...
7. ### equation

Hello, i would like to know what equation to use if i want to use the below condition if the result is 0% or in negative % then score is 0% and if result between 1% to 25% then score is 25% and so on till i reach score 76% till 100% then score is 100%
8. ### Linking data from another workbook using AVERAGEIF

Hi everyone, I am using an averageif equation, and in the equation I am referencing data from another workbook on my company's server. When I have said workbook open, the equation works and I get my number. However, if I close it, I get a #value ! error. Is there anyway to fix this error and...
9. ### Nested ISBlank

Hello I have 3 cells I would like to check if blank So if Cell B19 is blank check Cell B25 if not blank multiply B19*15 (then equation is done if its not blank, if blank go to next cell) If B25 is Blank go to Cell B27 if not blank multiply B27*10 (then equation is done if not blank, if blank go...
10. ### VBA to solve for equation based on missing variable

Hi all, first post here. I've been learning VBA, and I've found the best way for me is to jump into exercises I've never done before. I recently came across a problem and decided to take a shot at it. I'm trying to use VBA to solve for the equation A = (B/C)^D, where any one variable A, B, C...
11. ### Help Needed with simplifying

Is there a way to use the Countif function (or any function) to look up a range of criteria? Example: If i had a range of numbers (with repeating values), I would want to know How many times a range of numbers appear. Right now I use =COUNTIF(A1:A100, "20"), if i wanted to see how many times...
12. ### Putting an equation into solver

Hello, I need to input equations into solver in Excel (Its easy to do most of these outside but the automation is helpful) For example \$120=\$93.50*X+(S:S)*(\$3000-X) How would I type this equation into Excel to have it solved. NOTE: In this case S will be from a list of Values.
13. ### Equation for Data filtering

Hi I am after an equation either sumif or countif, whatever is best for the following two scenarios. Scenario One I have created a workbook on excel with several sheets that automatically filters names of people that have attached specific tasks they complete onto a summary sheet. The sheets...
14. ### Can a excel formula be made for this equation?

I may as well be reading Chinese as my math doesn’t yet extend this far. Please excuse me I am just an aspirant practitioner. Can an excel formula be made to solve given values/variables for this equation? Thanks in advance. :confused:;) https://ibb.co/b3GTr7W
15. ### Calculating Rounddown Future Value

Hi Everyone, I'd like to ask a question about a very simple excel problem but I don't know how to solve it, haha. I have a sequence formula like this: <tbody> 1000 5% =ROUNDDOWN(A1*(1+\$B\$1),0) =ROUNDDOWN(A2*(1+\$B\$1),0) =ROUNDDOWN(A3*(1+\$B\$1),0) =ROUNDDOWN(A4*(1+\$B\$1),0)...
16. ### Referencing a string of charcters in a cell as a cell reference.

Alright, so I have looked everywhere online and cant even find a specific way to do what I need or even if there is a way to do it. So right now I am trying to create a list of dates that always displays the last 8 entries of dates in a data pool. So when I add a new date with values it will...
17. ### Trendline equation in chart - need "m" and "b" linked to cell that updates dynamically with chart

I've read a few dozen posts on linking trendlines to cells, but none of them seem to offer a solution to my problem so far. The trendline equation on the chart automatically updates to reflect what data in a table is visible (not filtered out). All of the formula equations I've seen use the...

All, Trying to use lookup and address for the first time and think i am doing it wrong. SUMPRODUCT(--ISTEXT(address(7,LOOKUP(2,1/(G5:G15245<>""),ROW(G5:G15245))):LOOKUP(address(7(2,1/(G5:G15245<>""),ROW(G5:G15245)-300)))) So i have a ton of stuff in coulmn G I need to find the last value that...
19. ### indirect function - how to change row by dragging cell horizontally

Hi everyone, In B3, I have the equation: =AVERAGE(INDIRECT("b"&(today()-\$A2+5)):INDIRECT("b"&(today()-\$A3+5))) When I drag this equation horizontally the two ["b"}'s stay as b's. What can I do to have the two ["b"}'s change to the new column with everything else in the equation staying...
20. ### have index match return nothing

I have this equation {=INDEX(F7:AS7,1,MATCH(MAX(IF(F6:AS6>0,F6:AS6)),F6:AS6,0))} row 7 is a bunch of names what i want returned row 6 is maybe some numbers and maybe 0 and could all be 0 if all of row 6 is 0, i want the equation to return nothing. Now if they all go to 0, it retuns the last... Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle. ### 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.

### Which adblocker are you using?    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

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