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 164977 times)

Offline DanH

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2011
  • Posts: 2180
  • Total likes: 26
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Problem
« Reply #660 on: October 26, 2016, 01:38:07 PM »
(Email it to yourself and) open in google sheets. Then save it as an excel.
Highly doubt that will work..
For tech help feel free to Telegram me @DanTechSupp

Offline MarkS

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2009
  • Posts: 3747
  • Total likes: 30
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #661 on: October 26, 2016, 01:44:39 PM »
Highly doubt that will work..
I don't know if it still works but it definitely did for a long time.

Offline yesitsme

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2014
  • Posts: 3749
  • Total likes: 1351
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #662 on: October 26, 2016, 01:50:32 PM »
So I had the genius idea of making a excel document with important information password protected without wiring down the password.

Naturally I forgot the password, any ways to get around this and get in the file?
Send me the file I'll send it back unlocked
["-"]

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #663 on: October 26, 2016, 02:08:04 PM »
Send me the file I'll send it back unlocked
How?

Offline MAJ

  • Dansdeals Platinum Elite
  • ****
  • Join Date: May 2012
  • Posts: 454
  • Total likes: 4
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: NY
Re: Excel Problem
« Reply #664 on: October 26, 2016, 02:08:41 PM »
Highly doubt that will work..
did not work

Offline yesitsme

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2014
  • Posts: 3749
  • Total likes: 1351
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #665 on: October 26, 2016, 03:18:33 PM »
(Email it to yourself and) open in google sheets. Then save it as an excel.
What excel version did you use?
The workbook is protected or the worksheet?
« Last Edit: October 26, 2016, 03:26:58 PM by yesitsme »
["-"]

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #666 on: October 26, 2016, 04:25:33 PM »
(Email it to yourself and) open in google sheets. Then save it as an excel.
Didn't work for me on office 16

Offline MAJ

  • Dansdeals Platinum Elite
  • ****
  • Join Date: May 2012
  • Posts: 454
  • Total likes: 4
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: NY
Re: Excel Problem
« Reply #667 on: October 26, 2016, 05:28:33 PM »
What excel version did you use?
The workbook is protected or the worksheet?
2010
workbook

Offline DanH

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2011
  • Posts: 2180
  • Total likes: 26
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Problem
« Reply #668 on: October 26, 2016, 06:57:23 PM »
you can try:
Code: [Select]
magnet:?xt=urn:btih:8DEE683FB90A261535EEC5185A890D8AA7A31998&tr=http%3A%2F%2Fbt4.t-ru.org%2Fann%3Fmagnet
For tech help feel free to Telegram me @DanTechSupp

Offline MAJ

  • Dansdeals Platinum Elite
  • ****
  • Join Date: May 2012
  • Posts: 454
  • Total likes: 4
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: NY
Re: Excel Problem
« Reply #669 on: October 27, 2016, 09:31:21 AM »
you can try:
Code: [Select]
magnet:?xt=urn:btih:8DEE683FB90A261535EEC5185A890D8AA7A31998&tr=http%3A%2F%2Fbt4.t-ru.org%2Fann%3Fmagnet
where do i try this?

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #670 on: November 15, 2016, 04:26:24 PM »
Cell A1 has a date 11/1/2016

Cell A2 has value "Payments"

In Cell C1 I want to do = A1 & A2 To get : 11/1/2016 Payments. Instead I am getting:  42675Payments

Need to have date format. and also a space would be nice but not necessary.

Thanks

Offline mancunian

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2008
  • Posts: 1254
  • Total likes: 11
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #671 on: November 15, 2016, 04:31:54 PM »
=TEXT(A1,"m/d/yyyy")&" "&A2

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #672 on: November 15, 2016, 05:32:01 PM »
=TEXT(A1,"m/d/yyyy")&" "&A2
Cool thanks

Offline Centurion

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2012
  • Posts: 1312
  • Total likes: 2
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York / Jerusalem
  • Programs: spg plat,avis pres ,hertz plat ,AAexcutime, delta plat,hilton gold, united
Re: Excel Problem
« Reply #673 on: November 29, 2016, 12:29:20 PM »
good day,
looking for a formula ( for commission) if reach quota = 0.25 if exceed - on the extra i will pay $1.25
so if his quota is 1000 and he sold 2000 i would pay $250 plus $1250= total $1500
thanx
you can only make a first impression ONCE

Offline mancunian

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2008
  • Posts: 1254
  • Total likes: 11
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #674 on: November 29, 2016, 12:35:27 PM »
You do realize that if the guy sells $5,000, you'll be paying him $5,250 commission right?


=A2*0.25+(A3-A2)*1.25

Where A2=Quota and A3=Sales

Offline CZ60

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jul 2014
  • Posts: 431
  • Total likes: 38
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: New York
Re: Excel Problem
« Reply #675 on: November 29, 2016, 12:35:47 PM »
good day,
looking for a formula ( for commission) if reach quota = 0.25 if exceed - on the extra i will pay $1.25
so if his quota is 1000 and he sold 2000 i would pay $250 plus $1250= total $1500
thanx
Assuming your quota is in A4 and his actual sales are in B4 ...

=IF(B4>=A4,A4*0.25+(B4-A4)*1.25,0)

Offline mancunian

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2008
  • Posts: 1254
  • Total likes: 11
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #676 on: November 29, 2016, 12:36:38 PM »
Assuming your quota is in A4 and his actual sales are in B4 ...

=IF(B4>=A4,A4*0.25+(B4-A4)*1.25,0)
Ye my formula didn't account for sales < quota

Offline CZ60

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jul 2014
  • Posts: 431
  • Total likes: 38
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: New York
Re: Excel Problem
« Reply #677 on: November 29, 2016, 12:36:41 PM »
You do realize that if the guy sells $5,000, you'll be paying him $5,250 commission right?


It may not be dollars - it may be units/widgets etc...

Offline Centurion

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2012
  • Posts: 1312
  • Total likes: 2
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York / Jerusalem
  • Programs: spg plat,avis pres ,hertz plat ,AAexcutime, delta plat,hilton gold, united
Re: Excel Problem
« Reply #678 on: December 06, 2016, 09:02:37 PM »
Assuming your quota is in A4 and his actual sales are in B4 ...

=IF(B4>=A4,A4*0.25+(B4-A4)*1.25,0)

this is great thanx!
you can only make a first impression ONCE

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #679 on: December 09, 2016, 10:45:24 AM »
how do I fix my date format within a pivot table to short date??