statement

https://1drv.ms/x/s!AnJwxxiz0Ezpg8c6oid-OUrUmz6fiw I need help with a if statement in P16 answer show AWAY and P17 be HOME Thanks You Thomas

I'm trying to covert the following Excel IF statement to a custom column in Power BI: =IF(O2<>P2,IF(O2>0,O2,P2),IF(P2=0, N/A,P2)) (replacing the cells with the column names) I cannot for the life of me figure out the syntax. Any assistance is GREATLY appreciated.

HI I am having issues doing an if statement , i seem to get the wrong end result, below is the data i have <tbody> A 1 0.48 2 - 3 0 4 1 </tbody> now when i do this formula below i should get 175 but for some reason i get 75...

I have a spreadsheet where I'm trying to put together an IF statement which meets multiple criteria. Outline below: Column B - Type - "Risk" or "Issue" Column I - Probability - "1/2/3/4/5" (validated cell) Column J - Impact - "1/2/3/4/5" (validated cell) Column K - Rating - product of Column B...

Hello to all, I am new to the if statement and vlookup world and have been using A very simple if statement with great results =if(d22=0,(0),(c22)) Yes, simple but I like what it does and look to expand. I have a wb with a number of sheets. I want to place an if /vlookup statement in the...

Hi I am trying to do an IF then statement. I have a list of items that if a cell contains I want it to say Deduct or no deduct, no matter what I try the formula only returns No Deduct. The formula is listed below: =IF(OR(J876="EXTRA BUNDLING CHARG",J876="SPECIAL PACKAGING", J876="COMBO GASKET...

Help with countifs statement if that's what I should be using???=COUNTIFS(Bramshaw!C3:N3,I1,Lulworth!C3:N3,I1)for Bramshaw the number relating to I1 is 3 and Lulworth I1 is 1.When I enter the formula i get an answer of 1 rather than 4? Am I using the correct formula to add them together...

A UDF I was working on failed when passed data from a cell that was "empty". To get it to work, I had to change the If statement to this: If IsNumeric(parm) And Not IsEmpty(Parm) Then . . . Is this the correct (& optimal) statement?

I need to calculate based on the below chart but coming up with a negative # (I understand why) but can't figure out how to get an additional if statement to resolve or is there a better way to calculate <tbody> Fund Balance $750,000 Up to $499,999 2.25%...

Hello, Is there a way to highlight values that have been used in a formula :confused: Example formula =(SUMIFS(All!$B:$B,All!$A:$A,">=1/1/2018",All!$A:$A,"<=31/1/2018",All!$C:$C,"shop1")+(SUMIFS(All!$B:$B,All!$A:$A,">=1/1/2018",All!$A:$A,"<=31/1/2018",All!$C:$C,"shop2")))*-1 My data looks...

Hi I'm wondering if anyone can help with an issue I just can't seem to solve. I'm trying to use a nested IF OR statement to show a value in a cell from another sheet: =IF(OR(F7,F9,F11=Lists!A1),Lists!C5,IF(OR(F4,F7,F8,F9,F10,F11=Lists!A1),Lists!C6,"")) The first part of the statement works...

Hello, I have a nested if statement to return values once a certain number of units are deployed. What I'm having trouble with is how to structure the formula so that is returns zero once the condition is met. So for instance, the first time units deployed hits the 23-28 range, then return...

Good day, is there a way to make an IF statement, row per row? The condition is that A2 is blank, then if will look at A3, if still blank, it will proceed to A4, etc. Thanks

Hello all! I am having difficulty using multiple IF statements in 1 cell. There are 8 options the IF statement needs to check which are: if J9 = BB, insert "1" in cell B9 if J9 = OS, insert "2" in cell B9 if J9 = OST, insert "3" in cell B9 if J9 = VP, "4" if J9 = RR, "5" if J9 = A3, "6" if...

Hi, I am attempting to use the result of a VLOOKUP within the logical test of an IF statement, however I am getting a #NAME ? error. It's probably something simple but I have not managed to solve the issue with over an hour of Googling :( Cell AE29: =VLOOKUP(B29,'EMIS...

Hi, I have an if statement that is not quite working for me. Here is the code: =IF(ISNUMBER(AND(SEARCH("Comp",D27),Dashboard!$H$16="Yes")),IF(E27="WD","No",IF(AP27<=2,"Yes","No")),IF(ISNUMBER(AND(SEARCH("Open",D27),Dashboard!$H$15="Yes")),IF(E27="WD","No",IF(AP27<=2,"Yes","No")),"No")) It...

I am trying to do an if statement based on another if statement: So if someone is In a team I want the formula to do another If statement based on this. Below is my current formula: =IF(C2<54%,"1",IF(C2>=80%,"2","3")) But I need to repeat this if statement 3 times as I have 3 teams with...

Hello, I have yet another issue here with me. Below is a code I am using to track the availability of an item under the "textbox enter evet". It's working okay for now. However, I am trying to also track the item when the textbox changes its contents. That is when I click my listbox to...

Here is my nested IF statement. For some reason it has an issue when cells in column "J" are "Injector" and cells in column "M" are blank. Not sure why the IF statement isn't working on these cells. I'm telling it to look in column "N" for a date if the cell in column "J" is "Injector" so it...

I need your help writing an if/then statement in a pivot table - I need to write if c5 is = 1 and d5 is equal to 0, then "closed" otherwise "still open"