Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 68557 times)

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9177
  • Total likes: 258
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1185 on: May 15, 2018, 11:01:24 AM »
Workflowy. You won't know what you're missing until you try it.

Online ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6454
  • Total likes: 896
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: Excel Help and Problems
« Reply #1186 on: June 06, 2018, 05:51:10 PM »
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.
I just found a new supply of forks!

Offline Zubda

  • DansDeals Copper Elite
  • *
  • Join Date: Apr 2018
  • Posts: 11
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1187 on: June 06, 2018, 05:54:16 PM »
=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.

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1252
  • Total likes: 106
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1188 on: June 06, 2018, 06:01:01 PM »
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%,""))

Online ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6454
  • Total likes: 896
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: Excel Help and Problems
« Reply #1189 on: June 06, 2018, 06:12:58 PM »
Thanks to both of you!!! First formula had to change 0.25 to 0.025
I was able to figure that one out.  :)
I just found a new supply of forks!

Offline Zubda

  • DansDeals Copper Elite
  • *
  • Join Date: Apr 2018
  • Posts: 11
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1190 on: June 06, 2018, 08:25:11 PM »
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

Offline pinigee

  • DansDeals Copper Elite
  • *
  • Join Date: Oct 2015
  • Posts: 24
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: nyc
Re: Excel Help and Problems
« Reply #1191 on: July 05, 2018, 09:01:56 PM »
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

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1252
  • Total likes: 106
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1192 on: July 06, 2018, 12:10:13 AM »
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

Online Definitions

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jan 2018
  • Posts: 393
  • Total likes: 27
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Help and Problems
« Reply #1193 on: July 06, 2018, 01:28:39 AM »
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.
Jack of all trades, master of none.

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2646
  • Total likes: 91
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Help and Problems
« Reply #1194 on: July 06, 2018, 01:37:00 AM »
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.

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9177
  • Total likes: 258
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1195 on: July 06, 2018, 09:55:43 AM »
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
Workflowy. You won't know what you're missing until you try it.

Online churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6977
  • Total likes: 183
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1196 on: July 07, 2018, 10:09:46 PM »
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

Offline yesitsme

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2014
  • Posts: 1261
  • Total likes: 104
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
Re: Excel Help and Problems
« Reply #1197 on: July 16, 2018, 05:15:03 PM »
UniqueFirstLast
1dandeals
1dandeals
2jjdeals
3chaimMoskowits
4mosheaygayrt

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

Code: [Select]
=IF(B1&C1<>B2&C2,A1+1,A1)


 

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9177
  • Total likes: 258
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1198 on: July 16, 2018, 06:43:05 PM »
UniqueFirstLast
1dandeals
1dandeals
2jjdeals
3chaimMoskowits
4mosheaygayrt

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
Workflowy. You won't know what you're missing until you try it.

Online ChaimMoskowitz

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2014
  • Posts: 6454
  • Total likes: 896
  • DansDeals.com Hat Tips 1
  • Gender: Female
    • View Profile
Re: Excel Help and Problems
« Reply #1199 on: September 12, 2018, 11:52:09 AM »
How do I copy a sheet (tab on the bottom) from one file to another?
I just found a new supply of forks!