This nested if in a shared workbook is getting unwieldly. The one thing I can do, what I hope to do, is update the IF statement in Column I, Status, so that if always works.
The status text strings are found in the cells above columns 0 though P. (That is, the if refences are to O2, P2, etc.)...
Hello,
I am trying to do a If And with a vlookup within the same workbook.
IF(AND(IF(AF3431="Red",VLOOKUP(AG3431,'VLookup Table'!E:F,2,FALSE),IF(AF3431="Blue",VLOOKUP(AG3431,'VLookup Table'!E:F,2,FALSE),IF(AF3431="Green",VLOOKUP(AG3431,'VLookup...
So I am having trouble with my if statement.
My logical test is if G19>40,
If its true I want it be F19-(G19-40), however if F19-(G19-40) is a less than 0(or negative), then it needs to read"0"
if false f18.
HELP!
I am tring to have people exter a number between 1 & 4 in a cell in column E and have this in the cells in column F to display the corsponding text that goes with the number they entered.
Excel keeps saying the function is wrong and I can't seem to be able to figure out what it is I am doing...
Hello profs., I am having a long table containing about 20,000 rows (format is in numbers having 15 characters long), I need to get only the first 6 digits in the left for each number and then need to do an if statement with 12 conditions so to map each code with its correspondent company name...
I am attempting to deliver a pricing model (matrix). The model is dependent on the number of average transactions (x-axis) and the number of overall customer. As pricing increases, the incremental cost decreases (i.e. the incremental cost at 5,000 is less than that at 1,000).
I have created...
In Excel 2013, I'm trying to create a nested IF statement using wildcards. I have data similar to the following:
PC Unit Account
CMCPX 21002400 GOOD
CMOPX 21002400 BAD
CMOPX 70021160 GOOD
CMCPX 70021178 BAD
CMOPX 70021186 GOOD
CMCPX 21001599 GOOD
CMOPX 21003601 BAD
When "PC Unit" = "CMCPX"...
I am BRAND NEW to the forum so any help is very much desired. I am trying to figure out what I did wrong on the following equation:
=IF(Refi!$C$2>Proforma!L3, SUMIF('1st Mort'!$B$17:$B$256,Proforma!L3,'1st Mort'!$E$17:$E$256)+SUMIF('1st Mort'!$B$17:$B$256,Proforma!L3,'1st...
Hi
I am having a bit of trouble with my nested if statement. I seem to have got most the way.
I am trying to say if one cell is less than 11 and another cell is less than 6, return yes, otherwise no.
I am using the formula =IF(M2>11,yes,IF(I2<6,"yes","no"))
Which works until I get a...
Greetings,
I have a nested IF statement that I am using in an application I am building in Excel. I am using logic to get the current month and then evaluate whether the value is a number. I would like to know if there is a better way to perform what I am trying to accomplish using another...
Greetings all,
Long time troller, first time poster.
I'm building a spreadsheet that tracks total product packaging weight by multiplying packaging weight per unit by the number of units sold. e.g. 10grams of HDPE per unit x 1000 units sold = 10kg of HDPE.
I have a large worksheet with all...
Hi all,
Cell K2 is my Date of Arrival, Cell L2 is my Date of Departure.
I need to a formula in cell M2 that will do the following: if K2 < or = TODAY AND L2 > or = TODAY, then it outputs "In House"; if K2 > TODAY, then it outputs "Not Yet Arrived"; if L3 < TODAY, then it outputs "Departed"...
HELLO Excel Experts!
Goal = Return a value "0" if cell value is blank or "1" if value matches same one on other sheet.
I feel I'm close but can't figure this out. I think I need if statement to set conditions of "1" TRUE or "0" FALSE & vlookup to match values on two different worksheets. I...
Hi All,
I'm very new to this forum so please forgive me. I'm trying to create a compounding commission schedule that is as follows:
10% of the amount from $0 - $50,000 with a minimum of $1,000
5% of the amount from $50,001 – $100,000
3% of the amount from $100,001 - $250,000
2% of the...
OK The formula in C4 under PRICE is
=IF(ISBLANK(B4),"",IF(A4="I",150,IF(A4="T",120,IF(A4="S",75,))))
and the formula in E4 under NEW COST is
=IF(D4="D",C4*0.8,IF(D4="SD",C4-60,""))
What I want to do is have the cost under Price disappear if there is an amount under NEW COST.
<TABLE...
Afternoon,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
This one has been giving me nightmares, (Literary) all month.<o:p></o:p>
<o:p></o:p>
It is an IF statement which users ranges and arguments. I have similar, which works without...
Good Afternoon Ladies and Gents
(Excel 2003 (XP) user)
trying to nest up a few IF Formulas into one equation
IF(AND(B56=FALSE,B57=FALSE,B58=FALSE), “TICK PRICING OPTIONS”, “ ”)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...
Hi Folks,
I'm having a problem with a formula that has a series of "Nested IF" functions in it. Everything works fine, UNTIL I add the LAST "IF" function, then Excel 2003 returns, "The formula you typed contains an error" and highlights the second "AND" in the formula.
Here's the formula in...
Thank you in advance for all your help!
I am looking for the correct setup of a nested if statement with 4-5 arguments
if sales reach a certain thershold 1% bounus
if sales increase 5% - 10% = 2% bonus
if sales increase 11%-15% = 3% bonus
and if sales increase 15% = 4% bonus
Thanks...
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.