statement

I am trying to create a If...then....else if statement loop with a cut and paste function to another worksheet. I have one master data worksheet "CAS_PPDR" and I have a column E that has the GL category in it (Regular, BB, Overtime, Premium). Based on the information in that column, I would...

HI All, I am trying to create a calculated column using an if/and DAX statement in PowerPivot and for some reason I keep getting errors so I am not sure if its the formula or if I am completely unable to perform what I want. My formula is below, can someone please help =IF(([Actual Order...

Is it possible to combine an iferror statement and a countifs statement into one? Here is my current countifs: =COUNTIFS(AACH!C:C,">8/31/2019",AACH!C:C,"<10/1/2019",AACH!F:F,"Y")/COUNTIFS(AACH!C:C,">8/31/2019",AACH!C:C,"<10/1/2019") My current statement is returning #DIV/0! which is correct...

Good morning, I am trying to nest RoundUp Statement within an IF statement for a decimal place. For example if the value is 20.30 I would like it to read 20. If it is 20.50 it can remain the same. Your help is much appreciated.

I wasn't exactly sure how to word the title outside of providing the actual problem itself. I have a pivot table that has a dynamic amount of informaiton. My current pivot table has 27 unique dates, the next one I run could have 30 or even < 20. The column header we use is the Received Date...

I have several worksheets in the same Excel file where I need to clear the contents in these specific columns (A,D,G,J,M,P,S & V) starting at row 2 in each column. My worksheets are named (8am, 12pm, 2pm, 4pm and 6pm) - Here is the code so far that clears these contents but it seems like I...

I have this if/then statement that doesn't run correctly. lbSL is a label on a userform that displays 5.5% and it should execute the first part of the if/then statement. However, it executes the second part of the if/then statement. My guess the code does not recognize the lbSl.Caption as a...

I have a series of prices as; D4 = Item A, D5 = Item B D6 = Item C I have a IF statement in J15 which reads =IF(H15="YES",$D$4+D$6$,0) so adding Item A + Item C In I15, if this contains a "Yes", I want the above statement in J15 to add together all three items (so D4+D5+D6) What is the best...

Hello, I have the following formula in a cell: =IF(AND([@[Trans. Date]]>=DATE(2018,1,1),[@[Trans. Date]]<=DATE(2018,1,31)),"Jan",IF(AND([@[Trans. Date]]>=DATE(2018,2,1),[@[Trans. Date]]<=DATE(2018,2,28)),"Feb",IF(AND([@[Trans. Date]]>=DATE(2018,3,1),[@[Trans...

=IF(I119="1",E119+J119,0) with this formula, if the value doesn't show up, instead of seeing N/A's how would i make it so I see "-"'s instead?

I don't know if it is possible, but is there a way to use index/match in an IF statement? Or maybe something else will work. I have a range of A5:F250 with a list of events for different entries. Column A = First Names Column B = Last Names Column D = Name of Events (Birthday, Deceased...

Hello, I have one cell which contains 4 different words and want to do an if statement which shows when the word comes up then leave a blank cell. Please reply with if statement. Chris

I have a sheet which has a list of numbers ranging from -10000 to 10000. I need an IF statement which says if the number is less than -1500 then it should read "red" if it is less than -500 then read "amber" and if it is greater than -500 then should read "green" I can get it do parts but...

I need one of my match criteria to be an or statement. I am currently using the below =INDEX($I$37:$I$1128,MATCH(1,INDEX((D37=$D$37:$D$1128)*(F37=$F$37:$F$1128)*($G$37:$G$1128="Base"),0,1),0)) I want the last set to look for "Base" or "Allowance"...

Hello, I am trying to create a tool which dependent on year, will tell me whether to upgrade a phone or repair. I have go to it work with the year so that it either returns "repair and Replace" dependent on year... but i want to incorporate an and statement in this. the statement below is...

How to write a VBA code to get the below output. If Column A = Internal, Then column F = ok and If Column C = Long or Short Then column F = ok and if Column A is anything else, then it should check if Column C = Long or Short if yes then column F = ok else column F = check. Thank you in...

I have a workbook with a Labor/Equipment sheet. The sheet has dropdown menus for Employee, Title, Status (FT, PT, T) and Equipment. Labor costs are calculated based on work categories (A, B, C – G). Full time employee regular labor costs are not calculated for categories C – G. Part Time and...

I'm having a heck of a time figuring out a statement.... I need to know: if cell B4 is a NO, then 0 if cell B4 is a YES and cell C4 is a YES, then 10 if cell b4 is a YES and cell C4 is a NO, then 5 This is what I have, but it's coming up false...

I'm wondering if I can combine a sumifs statement with a filter I've applied? In the case of totals for example, I know to find the sum of all visible rows I have to use the subtotal formula rather than the sum formula. Similarly I'm wondering if there's something I can do for a sumifs? I want...

<tbody> Order Date Type Order Status Cost 2019-07-01 Bulk Completed $5 2019-07-09 Parcel Shipped $7 </tbody> I need to figure out the weekly shipping costs for Parcel packages. At the moment I'm doing it manually because I can't figure out how to write a sumif statement with a range of...