wrong

What am I doing wrong I am using this formula in cell E7 successfully =IF(D7-C7<0, 1+D7-C7, D7-C7). But when cell C7 has no data I do NOT want ‘0’ to appear in E7. I have tried various formulas including this one =IF(C7=””,””,D7-C7<0, 1+D7-C7, D7-C7) but it doesn’t work. Can someone please...

Hi all I have two formula but one have result, one have result = 0. I can;t find out the mistake of wrong formula: formula have result =+SUMPRODUCT((('ky1'!$E$2:$E$9999="0101")*(LEFT('ky1'!$A$2:$A$9999;6)="G03654"))*('ky1'!$F$2:$F$9999:'ky1'!$G$2:$G$9999)) formula result = 0...

anyone have an experience with offset returning a wrong data type error when increasing the height above 1? =OFFSET(A1,0,0,1,1) works just fine. =OFFSET(A1,0,0,2,1) produces wrong data type. Starting with a different reference doesn't seem to make a difference.

An extension to this problem: https://www.mrexcel.com/forum/excel-questions/1107696-approximate-match-vlookup.html I want to amend this formula: =IF(C3>INDEX($I$3:$I$7,MATCH(A3&"|"&B3,INDEX($G$3:$G$7&"|"&$H$3:$H$7,0),0)),"Y","N") to this...

Hi I have set-up the below but the LEN calculation seems wrong as LEN that isn't 15 is matching and doing the workday function. Can anyone see what is wrong please?

Hi, Not sure where I've gone wrong and this should be a fairly simple one hopefully. I have dates despatched in one column and time in stock in another. I wish to make a graph to show (hopefully) a quicker stock turnover as time goes by. I have the following, where Sheet1!A contains dates...

The following code worked fine until some of the computers were upgraded to Windows 10 from Windows 7. The upgraded computers work fine except for this code. The textbox appears and the correct password is entered... then they get "The password was wrong, try again." WHY!!!!!???? I do not...

I need help! I need help with a formula (in column D) to help me determine 2 categories: Right / Wrong If my customer name in column A contains the word "Apple" (could be variations of name, And if the country (column B) does not include "Ireland" and if the products (column C) includes "Pen"...

Hello all, In column Y I have quote numbers. In column A I need to put the quote number from column Y if it begins with CP or DC and blank if not. I tried this but the result is not right and returning (#VALUE!) =IF(MID(Y12,1,2="DC"),Y12,IF(MID(Y12,1,2="CP"),Y12,"")) Not sure what I am...

i have this: =WORKDAY(EOMONTH(p_quarter,MOD(-MONTH(p_quarter),3)-3),-1,holidays) , which gives me 12/28/18, but I'm looking for 12/31/18 since that is the last business day of the quarter, not 28. "p_quarter" is currently 3/29/19 ....

Application.Worksheets("Sheet5").DisplayFullScreen = True keep getting subscript out of range error plz help

Microsoft Excel 2007: I have the following formula in J45, which gives wrong answer as 0. =SUMIFS(D5:D33,C5:C33,">="&H40,E5:E33,"<="&H41,G5:G33,"TaxSave") D5:D33 Amount in numericals C5:C33 Start date in dd-mm-yyyy format E5:E33 End date in dd-mm-yyyy format G5:G33 Text msg...

Hello All, I'm trying to write: Countif G2:G32=G34 & I2:I32="Full Hol" But I cant make it work, where am I going wrong? Thanks

Hi, I try to change the color of the active cell before print the worksheet. I've got the following code: Private Sub Workbook_BeforePrint(Cancel As Boolean) Sheets("Invoice").Select c = ActiveCell.Address Range(c).Interior.ColorIndex = 2 Sheets("Uurlijst").Select d = ActiveCell.Address...

Hi The following if statement works perfect =IF(AND(B698="abc",G698="charge"),+C698,IF(AND(B698="abc",G698="payment"),-C698,IF(AND(B698="abc",G698="credit"),-C698,""))) When I add another condition ( made it red so it can be easier to see here), It returns “false” when the new...

Hi, I have written simple date check on open in one of my files, that prompts for password when it is expired and want to add wrong password counter and will add some more code to it on lets say 3 wrong attempts, but can not manage it to work. Private Sub Workbook_Open() Dim pass As Variant...

Hey guys, I need a small help. Cell G36 has the formulae =O38+O39 Cell F36 has the formulae =O32-G36 So i want to make a IF statement in cell D43, If G36 is equal to 0 (or if cell is blank) , then i want to show blank or 0 in D43. If G36 is not blank then, I want it to have this formulae...

I have a fairly simple formula that I am trying to amend so that inserting a line does not cause the cell values to change using the INDEX command. The formula I was using was: =IF(E6>0, E6, 0) Which I have updated to: =IF(INDEX(C:E,3,3>0),INDEX(C:E,3,3,0)) This produces a #VALUE error so...

Hello Have an issue. when entering wrong date ie 30-2-19 (30-Feb-2019) in txtDate.text it displays as 19-Feb-1930. i dont know why. Infact the below code has the msg of Invalid Date. but it by passes and shows wrong date altogether. The coding should not display any wrong dates Option...

Hi, Can one use AND in a while wend statement: When I use this statement, it does not read the AND statement, so even though there is data in my last column it exits the loops. Not too sure what I am doing wrong, or if I should not be using While and AND in the same statement. Any advice...