Search:

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

Page 1 of 6 1

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

by Eric W
Replies
1
Views
4

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

Welcome to the MrExcel forum!

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

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

by Eric W
Replies
3
Views
55

Re: Help, required single formula, instead of using 3

K6: =IF(C6=1,IF(C5=1,K5+1,1),IF(C5<>1,K5+1,1))
3. Thread: Volume Tier Formula

by Eric W
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. Thread: Calculate EXACT number to achieve an EXACT percentage

by Eric W
Replies
8
Views
214

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. Thread: Copy target value across based on cell value

by Eric W
Replies
3
Views
52

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. Thread: Copy target value across based on cell value

by Eric W
Replies
3
Views
52

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. Thread: Creating Random number generator but ignoring numbers given

by Eric W
Replies
8
Views
193

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. Thread: How do I take a total value and reduce the value of a cell and move to next until the total is met?

by Eric W
Replies
5
Views
143

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. Thread: Making the formula Dynamic based on Date Range

by Eric W
Replies
6
Views
191

Re: Making the formula Dynamic based on Date Range

Sure, same idea:

...
10. Thread: Volume Tier Formula

by Eric W
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. Thread: Calculate EXACT number to achieve an EXACT percentage

by Eric W
Replies
8
Views
214

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. Thread: making excel recognize it's 20XX not 19XX

by Eric W
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. Thread: How do I take a total value and reduce the value of a cell and move to next until the total is met?

by Eric W
Replies
5
Views
143

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. Thread: How do I take a total value and reduce the value of a cell and move to next until the total is met?

by Eric W
Replies
5
Views
143

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. Thread: Making the formula Dynamic based on Date Range

by Eric W
Replies
6
Views
191

Re: Making the formula Dynamic based on Date Range

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

by Eric W
Replies
8
Views
214

Re: Calculate EXACT number to achieve an EXACT percentage

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

by Eric W
Replies
3
Views
60

Re: Formula will not automatically adjust for different rows?

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

by Eric W
Replies
3
Views
60

Re: Formula will not automatically adjust for different rows?

Try:

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

by Eric W
Replies
8
Views
214

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. Thread: Making the formula Dynamic based on Date Range

by Eric W
Replies
6
Views
191

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. Thread: Volume Tier Formula

by Eric W
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. Thread: Find duplicate in row based on cell value.

by Eric W
Replies
3
Views
68

Re: Find duplicate in row based on cell value.

Happy to help! :cool:
24. Thread: Volume Tier Formula

by Eric W
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. Thread: Find duplicate in row based on cell value.

by Eric W
Replies
3
Views
68

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