equation

I have the following equation: =IF(AND(S19="yes",$V$5>0),VLOOKUP(I5,Table27,5,0),VLOOKUP(I5,Table27,4,0)) I'm having trouble adding to this equation: if S19="no", return a value of 0. Hoping explained my self and someone can help. Thanks Alex

Hello ! I am trying to get an equation fixed but I can't, lol... The working equation : =SUMPRODUCT((MONTH(Ledgers!$D$61:$D$80)=D211)*Ledgers!$I$61:$I$80) What I want to get done, I need the equation to technically do the above but to pull Number 61 & 211 from 2 cells in the sheet this...

Good day community, Would you help to write a vba code for following Mass balance & Data ReconciliationThe data reconciliation problem is solved using the method of Lagrange Multipliers. Let’s denote the vector of measurements as M, whose elements are the measurements of each mass variable. And...

Hey all. I tried using IF and I can't seem to get it to work. Using a basic checkbook worksheet (debit/credit total left in account etc...) Budget of $500 (starting amount) if amount spent (50) is being split 2 ways, in column b, i'd put then YES. Cell C would need the equation (500-(50/2)...

I created a scatter chart of some data and the equation returned was: <tbody> <tbody> y = 7E-24x[SUP]12.666 </tbody> <style>table { }.font5 { color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri...

Hello everybody, I am working on a thesis paper and have an equation that I need to be able to use in excel. I have no idea how to design an excel equation to match what I see. I thing that this will be an array function of some sort. The following are the parts of the equation: C = COST...

Hello, As the title says. For example, I want to do a list from "1" to "10" using data validation option and on the other cell there is an equation in which if the number goes below the "1" it will notify me with an error message.

I have 2 columns of data in a workbook and need to use VBA to extrapolate data. I need to know Y for any value of X. I have a range of known Ys and Xs (as below) The trickier part here might be that I only want to consider part of the range to extrapolate (say the middle 6 values) - I then to...

I am having trouble with a slope equation. =slope(if(Q7:1506>1,Q7:Q1506),if(And(F7:F1506>Y1480,F7:F1506<Y1481),F7:F1506)) ctrl+Shift+entr Column Q is a bunch of data numbers only Column F is dates Column Y are the 2 dates I am looking between I want to get the slop of the data between the dates...

I currently have the equation: =average('Enter Data Here'!C3:C33) in the second sheet. How can I apply the "indirect" function to this equation in a format that will allow me to drag the equation down the page? Thanks -Josh

I have been using Excel for years. but i hate if statements and im very bad at them. A1 is NO A2 is NO A3 is NO (The "NO" is a data validation list value) The equation reads =IF((A1="NO" & A2="NO & A3="NO"), 555,0) I keep getting Zero instead of 555. Argg. thanks for any help

Hi We have originally added fees to accounts based on a percentage of the original balance. We have a new client who wants their fees capped to specific amounts. I've done the formula for the new cliwnt but I'm struggling to add the equation to the original equation. The data looks like this...

I am just going to explain what I am trying to do to see if any of you guys can help me. Basically a simplified version of what I am trying to do is this: I want to refer to cell A1 in sheet1 from A1 in sheet2. I have a macro set up to insert a row above row 1 every day in sheet1; however...

Hello, Please I need you help with this equation I have Excel Sheet with Hijri Dates and I want to convert them to Gregorian I tried the below equation and worked but not able to convert all the cells one time, I have to manually input the equation on each cell to get what I need Can you...

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

I am currently trying to get a macro to basically copy the formulas I have set up from P15:AN15. Each column is a different equation and I need it to run the equation all the way down to the last row of column O. The spreadsheet I am using currently has multiple tabs but, will only need to...

I need help with an equation I've been working on for a few days now. I need the equation to take the information that is entered in one cell and split it into 4 parts in for other cells next to it while removing the extra characters. It also has to do this sequentially one row after another...

I need help with an equation I've been working on for a few days now. I need the equation to take the information that is entered in one cell and split it into 4 parts in for other cells next to it while removing the extra characters. It also has to do this sequentially one row after another...

Hi, I'm creating a sheet that shows story points per sprint in order to chart it. The table has projects in the first row and sprints for the columns and the data is filtered based on these and dropdown cells. Is there a way to put a wildcard into the dropdown cell that will allow the data to...