Search:

Type: Posts; User: Scott Huish; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.65 seconds.

  1. Replies
    4
    Views
    50

    Re: Day or Arrival, Plus 2

    That's what you asked for:


    Can you please provide a sample of what you need exactly?
  2. Replies
    4
    Views
    50

    Re: Day or Arrival, Plus 2

    Maybe I'm missing something but wouldn't that be:

    =WORKDAY(C16,2,M16:M28)
  3. Replies
    9
    Views
    22,385

    Re: convert M/D/YYYY to MM/DD/YYYY

    Assuming that value was in A1, perhaps something like this:

    =VLOOKUP(TEXT(A1,"mm/dd/yyyy"),A2:C100,2,0)
  4. Replies
    4
    Views
    66

    Re: @MATCH Function?

    Pretty sure, it's from Lotus 1-2-3.

    You can in Lotus like fashion, enter @SUM(A1:A3) but it converts it to Excel format.
  5. Re: Formula for if time is same, earlier or later?

    VBA does have a MOD function, however it only returns integer results, so would not be useful here.
  6. Re: Formula for if time is same, earlier or later?

    If there are dates in the cells with the times, you could eliminate the nested IF like this:

    =TEXT(MOD(S2,1)-MOD(R2,1),"""LATER"";""EARLIER"";""SAME""")
  7. Replies
    5
    Views
    31

    Re: time format

    You can put in 112:00
    and format as [h]:mm
  8. Replies
    10
    Views
    262

    Re: Univers and Channels for pixels

    Here is the sample you gave, but I don't understand what math you use to get the number for each column after the value you put in Column A. Can you please clarify?

    <b>Excel 2010</b><table...
  9. Replies
    5
    Views
    54

    Re: =if(condition,,)

    Just to return TRUE/FALSE:
    =E2&gt;50
  10. Replies
    47
    Views
    241,698

    Re: INSERT A SPACE INTO A TEXT VALUE

    :eeek:
  11. Replies
    4
    Views
    145

    Re: "Greater than" > rersults

    Personally, I would use COUNT, but same principle:

    =IF(COUNT(H4,J4)<2,"",IF(H4>J4,C4,O4))
  12. Replies
    4
    Views
    101

    Re: IF "x" is within all columns

    =IF(COUNTIF(A1:IP1,"*exclude*"),"exclude included","exclude not included")
  13. Re: VBA Close With Save Causes Runtime Error

    Please continue your question in your original post.https://www.mrexcel.com/forum/excel-questions/1109966-vba-close-save-causes-runtime-error.html
  14. Replies
    8
    Views
    183

    Re: If Statment Help

    Like this?

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  15. Replies
    8
    Views
    183

    Re: If Statment Help

    Perhaps:
    =IF(AND(A2<>"",C2<>""),A2&" "&REPLACE(C2,1,FIND(" ",C2),""),IF(C2=C1,B1,""))

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border:...
  16. Re: Finding row number of the last date in a given month

    That won't work because the amount of dates in May is greater than the largest value in that sample.

    Perhaps:
    =LOOKUP(9.99999999E+307,IF(TEXT(B2:B5,"mm/yyyy")="05/2019",B2:B5),ROW(B2:B5))
    ...
  17. Replies
    7
    Views
    363

    Re: A better formula?

    More specifically, if it contains a non-zero number, it would return 1. If it contained 0, it would return 0.
  18. Replies
    7
    Views
    363

    Re: A better formula?

    Yes, if a number is in that spot, non-zero is TRUE and zero is FALSE.
  19. Re: VBA to extract variable length number, following a variable character

    =LOOKUP(9.999999999E+307,MID(A2,FIND(".",A2)+1,ROW(INDIRECT("1:15")))+0)

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  20. Replies
    7
    Views
    363

    Re: A better formula?

    You could shorten it a little bit by writing it like this:
    =IF(A2*B2,C2/ABS(B2),SIGN(C2))
  21. Replies
    4
    Views
    106

    Re: Formula Help

    How about:
    =MEDIAN(10,A1,100)
  22. Replies
    9
    Views
    246

    re: Nested formula problem

    You shouldn't put numbers in quotes, that makes them text.
    =IF(AND(X3<15,X3>7),1,IF(AND(X3<80,X3>0),2,IF(AND(X3<0,X3>-3),3,IF(AND(X3<-3,X3>-3),4,"N"))))

    Your last choice doesn't make sense though...
  23. Replies
    8
    Views
    358

    Re: SUMPRODUCT error when blank cell

    Ok, but blanks still evaluate to 0. Do you mean they're not actually blank, as in empty string "" or space " " or what?

    As you can see, it's not failing as you have described the problem:
    ...
  24. Replies
    9
    Views
    246

    re: Nested formula problem

    I would check the entire range at once:

    =IF(COUNTIFS(X3:AB3,">2",X3:AB3,"<4")=5,"Yes","No")
  25. Replies
    8
    Views
    358

    Re: SUMPRODUCT error when blank cell

    If columns B & E are actually empty, that would equate to 0 in your formula. So what is your problem exactly?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4