Search:

Type: Posts; User: Eric W; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.26 seconds.

  1. Re: New at Excel - help with an addition/multiplication nested formula

    Welcome to the MrExcel forum!

    How about:

    =4675+MAX(0,ROUNDUP((B2-30000)/1000,0)*165)

    where the weight is in B2.
  2. Re: Help, required single formula, instead of using 3

    How about:

    K6: =IF(C6=1,IF(C5=1,K5+1,1),IF(C5<>1,K5+1,1))
  3. Replies
    9
    Views
    178

    Re: Volume Tier Formula

    I'm not sure what else to tell you. Maybe your browser shows the icons in a different location. If you hover your mouse over the icons, do any of them have a tool-tip that says "Table"?
  4. Re: Calculate EXACT number to achieve an EXACT percentage

    I'm glad I could help out! :cool:

    And I'm more than old enough to drink! :beerchug:

    And while I appreciate the offer of a donation, I'd prefer you just pay it forward. Help out a stranger, or...
  5. Re: Copy target value across based on cell value

    Sure.

    =IF(OR(B$8<$B2,B$8>$B2+$C2-1),"",$E2)

    The value in red is the week #, which it gets from row 8. That's why the $ is used. The value in blue is the start week from $B2. As you drag the...
  6. Re: Copy target value across based on cell value

    Something like this?

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  7. Re: Creating Random number generator but ignoring numbers given

    To avoid getting duplicate values in D1 and D2, probably the easiest way is to put this formula in O1: =D1
    Then in the D2 formula, change the M1:N1 to M1:O1 in 2 places. If you have something...
  8. Re: How do I take a total value and reduce the value of a cell and move to next until the total is met?

    Open a COPY of your workbook. I assume a starting range like this:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse:...
  9. Re: Making the formula Dynamic based on Date Range

    Sure, same idea:

    ...
  10. Replies
    9
    Views
    178

    Re: Volume Tier Formula

    In order to use the Table tool, click on Reply to Thread, then in the bottom right, click Go Advanced. You'll see a slightly larger box with 3 rows of icons on top. Click on the first icon in the...
  11. Re: Calculate EXACT number to achieve an EXACT percentage

    I wish you'd mentioned the M4 and O4 values earlier. It is impossible to figure out the percentage without knowing them. I tried to recreate your spreadsheet as best I could from your example and...
  12. Replies
    12
    Views
    122

    Re: making excel recognize it's 20XX not 19XX

    There is a Windows setting to handle this.

    Click Control Panel > Time & language > Under "Related settings" on the right: Additional date, time, & regional settings > Change date, time, or number...
  13. Re: How do I take a total value and reduce the value of a cell and move to next until the total is met?

    This is why I said "maybe something like this". I'm not entirely sure what your layout is like. Based on what you posted, it appeared that the top grid showed how many items were in each "bucket". ...
  14. Re: How do I take a total value and reduce the value of a cell and move to next until the total is met?

    Maybe something like this:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  15. Re: Making the formula Dynamic based on Date Range

    Happy to help! :cool:
  16. Re: Calculate EXACT number to achieve an EXACT percentage

    What is the formula you use to calculate the percentages?
  17. Re: Formula will not automatically adjust for different rows?

    Happy to help! :cool:
  18. Re: Formula will not automatically adjust for different rows?

    Try:

    =SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$32:$A$34&"'!B"&ROW(A11)&":K"&ROW(A11)),"<>"))
  19. Re: Calculate EXACT number to achieve an EXACT percentage

    Welcome to the forum.

    When you calculate a percentage, you are essentially comparing 2 numbers. You only provided one number, 4,250. However, 4,681 is 67.201% of 6,965.67. So apparently,...
  20. Re: Making the formula Dynamic based on Date Range

    Possibly:


    =INDEX(LINEST(OFFSET(I1:I12,MATCH(EOMONTH(TODAY(),-12),A1:A1000,0)-1,0),OFFSET(J1:J12,MATCH(EOMONTH(TODAY(),-12),A1:A1000,0)-1,0)),2)*12

    Longer, but non-volatile:

    ...
  21. Thread: Match & sum

    by Eric W
    Replies
    3
    Views
    68

    Re: Match & sum

    Possibly:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  22. Replies
    9
    Views
    178

    Re: Volume Tier Formula

    I'm a little unsure how else I can help. I need to understand why the formula does not work as you expect. Somehow you need to explain that. Possibly in words, although "it does not work to what I...
  23. Re: Find duplicate in row based on cell value.

    Happy to help! :cool:
  24. Replies
    9
    Views
    178

    Re: Volume Tier Formula

    Other than spacing, my formula generated the same numbers as your original post. Is that not what you're looking for, or do you not need help anymore?
  25. Re: Find duplicate in row based on cell value.

    Welcome to the MrExcel forum!

    Assuming your range starts in cell A1 (the word "Title"), try this:

    Select columns B:G. Click Conditional Formatting > New Rule > Use a formula > and enter:
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4