Excel Help and Problems

[Something Fishy]

So how does Excel know which ones to add it to? Are you only applying the conditional formatting to those cells?

Correct.

You can do it in google sheets by applying a number format. Select the cell(s) you want, click Format > Number > More Formats > Custom Number Format. Enter this for the format:

Code: [Select]

#,#+(won't work if you have decimals, we'll have to tweak it then)

Awesome, thanks!

Worked great for 5000+ (I don't need decimals here), but isn't working for 100s. I suppose I could instead use 100+, 200+, etc. if needed.

[etech0]

Correct.

Awesome, thanks!

Worked great for 5000+ (I don't need decimals here), but isn't working for 100s. I suppose I could instead use 100+, 200+, etc. if needed.

Funny that it's not working for the 100, 200... it works for me. What's it showing you?

[Something Fishy]

Funny that it's not working for the 100, 200... it works for me. What's it showing you?

It says invalid format as soon as I add the s.

[etech0]

It says invalid format as soon as I add the s.

Ah, I see. Try putting the s in quotes

[Something Fishy]

Ah, I see. Try putting the s in quotes

Bingo!

Thanks a lot.

[etech0]

Bingo!

Thanks a lot.

Pleasure!

[ChaimMoskowitz]

Cell 1 = Qty
Cell 2 = A or B
Cell 3 = Result

I want to multiply cell 1/cell 2.
If cell 2 is "A" I want to multiply cell 1 by 2.5%
If cell 2 is "B" I want to multiply cell 1 by 3%
What would be the formula for cell 3?
Hope this makes sense.

[Zubda]

=cell1 * if(cell2="A",0.25,0.03)

Cell 1 = Qty
Cell 2 = A or B
Cell 3 = Result

I want to multiply cell 1/cell 2.
If cell 2 is "A" I want to multiply cell 1 by 2.5%
If cell 2 is "B" I want to multiply cell 1 by 3%
What would be the formula for cell 3?
Hope this makes sense.

[Yisroel Tech]

Cell 1 = Qty
Cell 2 = A or B
Cell 3 = Result

I want to multiply cell 1/cell 2.
If cell 2 is "A" I want to multiply cell 1 by 2.5%
If cell 2 is "B" I want to multiply cell 1 by 3%
What would be the formula for cell 3?
Hope this makes sense.

If I understood correctly, it'll be:

Code: [Select]

IF(A2="A",A1*2.5%,IF(A2="B",A1*3%,""))

[ChaimMoskowitz]

Thanks to both of you!!! First formula had to change 0.25 to 0.025
I was able to figure that one out. 

[Zubda]

Thanks to both of you!!! First formula had to change 0.25 to 0.025
I was able to figure that one out. 

Sorry my mistake.. happy to help

[pinigee]

Hi there,
I want to calculate master carton sizes. For example I have a camera box that I need to ship 20 pcs to Amazon, I want a formula where I type in the size of the camera box and how many I need to ship it should tell me which size box I'll need..  even more if Excel can be smart enough to either give me a few options or perhaps can it be smart enough to give me normal size box that equals more or less proportion as opposed to giving me a narrow tall box.

Thanks in advance

[Yisroel Tech]

Hi there,
I want to calculate master carton sizes. For example I have a camera box that I need to ship 20 pcs to Amazon, I want a formula where I type in the size of the camera box and how many I need to ship it should tell me which size box I'll need..  even more if Excel can be smart enough to either give me a few options or perhaps can it be smart enough to give me normal size box that equals more or less proportion as opposed to giving me a narrow tall box.

Thanks in advance

Far too complicated than what I believe Excel can do. See here https://stackoverflow.com/questions/140406/how-can-i-programmatically-determine-how-to-fit-smaller-boxes-into-a-larger-pack

[Definitions]

Hi there,
I want to calculate master carton sizes. For example I have a camera box that I need to ship 20 pcs to Amazon, I want a formula where I type in the size of the camera box and how many I need to ship it should tell me which size box I'll need..  even more if Excel can be smart enough to either give me a few options or perhaps can it be smart enough to give me normal size box that equals more or less proportion as opposed to giving me a narrow tall box.

Thanks in advance

I can't help you, but you were michavein exactly to an app I wanted to develop. If only I knew how to code.

[skyguy918]

Far too complicated than what I believe Excel can do. See here https://stackoverflow.com/questions/140406/how-can-i-programmatically-determine-how-to-fit-smaller-boxes-into-a-larger-pack

Excel can handle it just fine, though it would obviously not be the optimal tool for the job. The issue is having the mathematical know how and programming skill to pull it off, no matter the tool.

Anyway, to the OP, just search 3d bin packing calculator - you should be able to find something useful pretty quickly.

[etech0]

Excel can handle it just fine, though it would obviously not be the optimal tool for the job. The issue is having the mathematical know how and programming skill to pull it off, no matter the tool.

+1, you can do almost anything with VBA, the question is if you should

[churnbabychurn]

Excel can handle it just fine, though it would obviously not be the optimal tool for the job. The issue is having the mathematical know how and programming skill to pull it off, no matter the tool.

Anyway, to the OP, just search 3d bin packing calculator - you should be able to find something useful pretty quickly.

+1 I would think it's just a math thing that Excel can definitely do

[yesitsme]

Unique	First	Last
1	dan	deals
1	dan	deals
2	jj	deals
3	chaim	Moskowits
4	moshe	aygayrt

How do You add a number if first and last arent the same?

Code: [Select]

=IF(B1&C1<>B2&C2,A1+1,A1)


 

[etech0]

Unique	First	Last
1	dan	deals
1	dan	deals
2	jj	deals
3	chaim	Moskowits
4	moshe	aygayrt

How do You add a number if first and last arent the same?

Code: [Select]

=IF(B1&C1<>B2&C2,A1+1,A1)

Code: [Select]

=IF(OR(B3<>B2,C3<>C2),A2+1,A2)Note: it doesn't actually check for unique, just if it's the same as the row above, so your data needs to be sorted

[ChaimMoskowitz]

How do I copy a sheet (tab on the bottom) from one file to another?