Topic Wiki

Rule 1: Did you try A.I? Right before you click post, give it a quick run. Most excel questions can be answered very quickly, thoroughly, and clearly via chatgpt. Wrong answer, or having trouble with the correct wording of the prompt? Post for help

=================
For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by Jojo202 on March 01, 2024, 12:09:44 AM »

« previous next »
Pages: 1 ... 28 29 30 31 32 33 [34] 35 36 37 38 39 40 ... 84   Go Down

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

Offline DanH

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

Offline MarkS

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

Offline yesitsme

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2014
  • Posts: 5116
  • Total likes: 2238
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #662 on: October 26, 2016, 01:50:32 PM »
Quote from: MAJ on October 26, 2016, 01:30:04 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
Logged
["-"]

Offline churnbabychurn

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

Offline MAJ

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

Offline yesitsme

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2014
  • Posts: 5116
  • Total likes: 2238
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #665 on: October 26, 2016, 03:18:33 PM »
Quote from: MarkS on October 26, 2016, 01:34:49 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 »
Logged
["-"]

Offline churnbabychurn

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

Offline MAJ

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

Offline DanH

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2011
  • Posts: 2181
  • 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
Logged
For tech help feel free to Telegram me @DanTechSupp

Offline MAJ

  • Dansdeals Platinum Elite
  • ****
  • Join Date: May 2012
  • Posts: 486
  • Total likes: 6
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: NY
Re: Excel Problem
« Reply #669 on: October 27, 2016, 09:31:21 AM »
Quote from: DanH 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
where do i try this?
Logged

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7647
  • Total likes: 301
  • 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
Logged

Offline mancunian

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2008
  • Posts: 1301
  • Total likes: 17
  • 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
Logged

Offline churnbabychurn

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

Offline Centurion

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2012
  • Posts: 1310
  • Total likes: 5
  • 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
Logged
you can only make a first impression ONCE

Offline mancunian

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2008
  • Posts: 1301
  • Total likes: 17
  • 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
Logged

Offline CZ60

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jul 2014
  • Posts: 429
  • 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 »
Quote from: Centurion 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
Assuming your quota is in A4 and his actual sales are in B4 ...

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

Offline mancunian

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jul 2008
  • Posts: 1301
  • Total likes: 17
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #676 on: November 29, 2016, 12:36:38 PM »
Quote from: CZ60 on November 29, 2016, 12:35:47 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
Logged

Offline CZ60

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jul 2014
  • Posts: 429
  • 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 »
Quote from: mancunian 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?


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

Offline Centurion

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2012
  • Posts: 1310
  • Total likes: 5
  • 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 »
Quote from: CZ60 on November 29, 2016, 12:35:47 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!
Logged
you can only make a first impression ONCE

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7647
  • Total likes: 301
  • 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??
Logged
Pages: 1 ... 28 29 30 31 32 33 [34] 35 36 37 38 39 40 ... 84   Go Up
« previous next »