1. D

    Eliminate #DIV/0! with IFERROR

    Hi there I'm having a brain freeze with an IFERROR to eliminate the #DIV/0! after a simple calculation and it's driving me insane... the formula is =(E108-C108)/C108 the result of course where there are zeros is #DIV/0!. I have tried a few variations unsuccessfully any help will be greatly...
  2. D

    If Error statement

    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...
  3. B

    IFERROR Formula help

    I could use some help with this formula. First time using an IFERROR formula so not sure what I'm doing wrong. I keep getting a "too few arguments error". Any help would be appreciated. =IFERROR(INDEX('[TICKET STEP LONG.xlsx]RAW_COMPLETIONS'!$B:$B,MATCH(G2,'[TICKET STEP...
  4. M

    Userform - If value is not found then displays a MsgBox

    Hi - I was hoping you could help me solve the following. With the following code I can get a list of values from a Table and displayed on an UserForm; however, I would like to have a msgbox when the value is not found...
  5. F

    Indirect, SumProduct and Errors

    Hi all, I am currently using sumproduct to find out numbers in a particular column in a 2nd spreadsheet. This formula works fine in column B: =SUMPRODUCT(('Y:\National Careers Service - Mail Merge\Brentwood\[Brentwood.xlsm]a_Main'!$AR$1:$AR$10000=B4)+0,('Y:\National Careers Service - Mail...
  6. R

    copying data from one sheet to another providing a specific condition is met

    Thank you and I appreciate all assistance! Prior to updating to WIN10 and O365 I was able to have the following condition work {=IFERROR(INDEX(Incident!P:P,SMALL(IF((Incident!$Q$2:$Q$301="Yes"),ROW(Incident!$P$2:$P$301)),ROWS(Incident!$p$1:p1))),"")} What this did was go to my Incident sheet...
  7. M

    IFERROR / #DIV/0! causing issues to another formula

    So I have this (the below) excel formula that does work, =IF('Q1 - Individual Performance'!N9<=60%, "0", IF('Q1 - Individual Performance'!N9<=80.99%, "1", IF('Q1 - Individual Performance'!N9>=81%, "2"))) However the sheet it is reading from has lots of #DIV/0! on there. So I have added in an...
  8. B

    Formula to VBV - weeks of cover

    HI All, Thank you for your help in advance.Im really struggle to translate one formula to the code. Below formula is calculating weeks of stock cover based on deliveries and demand. Unforgettably it have plenty of "if" slowing down the report. Im looking to translate this to VBA code. Is anyone...
  9. B

    Calculating percentages - error

    Please help I am trying to calculate data and find the increased or decreased percentage between weeks: see below : <tbody> <tbody> A1 A2 A3 <tbody> Actions on Page (this wk) </tbody> Actions on Page (last wk) total action % 1 0 0.00% </tbody> </tbody> In A3 i currently have the...
  10. I

    Help with putting a formula into a cell in vba keep getting error

    When I try to put a formula into a cell in vba using Range("A2").formula="=iferror(vlookup(A1,'array sheet1'!A2:B20,2,false),"")" I get application-define or object-define error I use iferror so when A1 is blank I don't get #N/A in A2 Is there another way to do this? Help!
  11. S

    weekdaty Average IFs formula

    Hello, I'm having trouble with the formula below, Im getting "Too few arguments" . Where am i going wrong with the formula below? CELL H2 FORMULA =IFERROR(AVERAGEIFS(C2:C11,"<>100%", C1:E1,G2,A2:A11,H1)"CHECK") <tbody> a b c d e f g H I J K L M N O P Q R 1 Name John Jacob Jill 1 2...
  12. E

    INDEX when a cell has multiple text and return a value

    Hi Everyone, I have this formula that I got working for what I want and now I am trying to add another level of complexity to it. Below is the formula I use to search for a Person's name and if that person's name matches then it will show the task assigned to that person...
  13. E

    Insert IFERROR( and ,"-") at the begining and end of formulas?

    How can I insert IFERROR( and ,"-") at the begining and end of formulas? With search/replace? Thanks!
  14. A

    IFERROR Formula

    Hi all I have the following formula =IF(P44>5,"",1) which is looking up a formula in cell P44 of =WEEKDAY(O40,2). Now when i get a #VALUE error I have tried to use the formula =IF(ISERROR((P44>5,"",1)),"", 1) but i get a message box saying "There's a problem with this formula Not trying to...
  15. C

    IFERROR array formula with 0 for results

    Can anyone assist me with this IFERROR formula; I can'tseem to get rid of the 0 (zero) when I copy the formula to the rest of thecolumn. {=IFERROR(INDEX('RAWDATA'!$N:$N,SMALL(IF('ERProjects'!$B$4='RAWDATA'!,$R:$R,ROW('RAWDATA'!$R:$R)-MIN(ROW('RAWDATA'!$R:$R))+1,""),ROW()-3),"")} Once all the...
  16. M

    SUMIFS with multiple Criteria

    I'm trying to sum data based on a phone time for a person between two dates. I'm returning a blank value in the cell currently and can't figure out why. I've watched multiple videos to find a solution and i must be missing something. Formula...
  17. I

    IFERROR vs ISERROR: what would ISRROE solution be?

    Using Excel 2010 I have numerous sheets with names in column E, with names on some sheets as Last, First, and other sheets as Last First Initial. Worked all day on trying to get the below formula working but to no avail and then I uses IFERROR and it worked, but I would still like to know what...
  18. O

    VBA Code for Formula

    Thanks in advance for any suggestions for which I will provide feedback. I am getting an error on the following formula as it's when i added, the "N/A" part for the IFERROR. Cells(i, 4).Formula = "= IFERROR( MATCH(TRUE,INDEX(Sheet1!E" & i & ":" & LastColumnLtr & i & "<>0,),0)," & ""N/A" )"...
  19. Z


    Good day Could someone please assist with including IFERROR into this formula. The displayed error is "#VALUE!". =(SUMPRODUCT(('Data Sheet'!$A$4:$A$1000>=$F$10)*('Data Sheet'!$A$4:$A$1000<=$N$6)*('Data Sheet'!$BC$4:$BC$1000))) IFERROR range BC4:BC1000. Thank you in advance. Z
  20. A

    Nested IF formula with wildcard

    I am setting up a spreadsheet to collect monthly figures. Of these figures I want excel to automatically calculate a percentage using two figures. I have this formula just fine. I want to have the formula present for all future months so that when I input the figures it automatically calculates...

Some videos you may like

This Week's Hot Topics