Quick Excel Question - Honda Motorcycles - FireBlades.org
Off-Topic Discussion of anything that doesn't fit anywhere else. If it's related to motorcycles in any way, DO NOT post it here. Post it in General Discussion or a more specific forum.

User Tag List

 
LinkBack Thread Tools
post #1 of 14 Old 07-11-2005, 2:16 PM Thread Starter
Supporting Member
 
tigerblade's Avatar
 
Join Date: 11-14-2001
Location: Columbia, MO
Posts: 5,711
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 32
             
Quick Excel Question

I need to reference a cell in a text string and can't remember how to do it. Example, I have a calculated value in cell C3 of "180" and I need to have a sentence elsewhere that says "180 payments". How do I get the cell value from C3 into the text string?

TIA

Is a paradigm worth 20 cents?
tigerblade is offline  
Sponsored Links
Advertisement
 
post #2 of 14 Old 07-11-2005, 2:26 PM
dB
 
Join Date: 04-17-2002
Posts: 1,666
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 0
   
Re: Quick Excel Question

If I'm reading that right, use the CONCATENATE function. It's in the Text group.

edit: Example: =CONCATENATE(C3,"payments")

Last edited by dB; 07-11-2005 at 2:32 PM.
dB is offline  
post #3 of 14 Old 07-11-2005, 2:42 PM
 
Join Date: 07-25-2002
Posts: 4,668
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 0
             
Re: Quick Excel Question

or

=C3& " payments"
RRWANTR is offline  
Sponsored Links
Advertisement
 
post #4 of 14 Old 07-11-2005, 2:46 PM
 
Join Date: 11-08-2001
Posts: 5,997
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 0
             
Re: Quick Excel Question

Quote:
Originally Posted by RRWANTR
or

=C3& " payments"
He'll go with the other one since it looks mo' smarter. He did that when I sent him a date formula last week (went with the more complicated one that he found somewhere else).
Pete is offline  
post #5 of 14 Old 07-11-2005, 2:48 PM Thread Starter
Supporting Member
 
tigerblade's Avatar
 
Join Date: 11-14-2001
Location: Columbia, MO
Posts: 5,711
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 32
             
Re: Quick Excel Question

I think it's working. Thanks to everyone here not named Pete.

Is a paradigm worth 20 cents?

Last edited by tigerblade; 07-11-2005 at 2:49 PM.
tigerblade is offline  
post #6 of 14 Old 07-11-2005, 2:51 PM
 
Join Date: 07-25-2002
Posts: 4,668
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 0
             
Re: Quick Excel Question

Quote:
Originally Posted by Pete
He'll go with the other one since it looks mo' smarter. He did that when I sent him a date formula last week (went with the more complicated one that he found somewhere else).

I guess he's not a fan of the KISS method.
RRWANTR is offline  
post #7 of 14 Old 07-11-2005, 2:56 PM Thread Starter
Supporting Member
 
tigerblade's Avatar
 
Join Date: 11-14-2001
Location: Columbia, MO
Posts: 5,711
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 32
             
Re: Quick Excel Question

Quote:
Originally Posted by RRWANTR
I guess he's not a fan of the KISS method.
Nah, I'd rather dazzle 'em with formulas.

Both ways work. The CONCATENTATE fuction does seem to work nicely though since you can just tab from field to field and build your text. I'm sure they both have their merits.

Is a paradigm worth 20 cents?

Last edited by tigerblade; 07-11-2005 at 2:59 PM.
tigerblade is offline  
post #8 of 14 Old 07-11-2005, 3:01 PM
dB
 
Join Date: 04-17-2002
Posts: 1,666
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 0
   
Re: Quick Excel Question

Quote:
Originally Posted by RRWANTR
or

=C3& " payments"
dB is offline  
post #9 of 14 Old 07-15-2005, 12:12 PM
 
phobiaphobe's Avatar
 
Join Date: 05-23-2004
Location: Omnipresent
Age: 37
Posts: 11,499
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 43
                     
Send a message via MSN to phobiaphobe
Re: Quick Excel Question

Ok I've got one... Anyone use DATEVALUE

I have 2 columns with dates; THe first column is the start date on a rental contract and the second column is today's date. edit: (or the closing date of the contract)

I want warnings when the contract is 70, 80, and 89 days old. I need a third column to have an "if" formula that gives me some sort of text as a warning.

I think I need to use a datevalue for the start date argued against a datevalue for todays date.

Any help would be much appreciated.

And then there's this asshole...

Last edited by phobiaphobe; 07-15-2005 at 12:15 PM.
phobiaphobe is offline  
post #10 of 14 Old 07-15-2005, 12:45 PM
dB
 
Join Date: 04-17-2002
Posts: 1,666
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 0
   
Re: Quick Excel Question

Check out the DAYS360 function.

Assuming start date is column A and end date is column B:

=IF((DAYS360(A1,B1))>70, "Over 70", "")

And the fully monty would be:

=IF(DAYS360(A1,B1)>70, IF(DAYS360(A1,B1)>80, IF(DAYS360(A1,B1)>89, "Over 89", "Over 80"), "Over 70"), "")


I'm sure RRWANTR or "PETE" will be here shortly to give you the 5 character solution.

Last edited by dB; 07-15-2005 at 1:28 PM.
dB is offline  
post #11 of 14 Old 07-15-2005, 2:52 PM
 
phobiaphobe's Avatar
 
Join Date: 05-23-2004
Location: Omnipresent
Age: 37
Posts: 11,499
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 43
                     
Send a message via MSN to phobiaphobe
Re: Quick Excel Question

HOly **** that worked perfectly. YOu're a ****ing wizard.

Thanks

And then there's this asshole...

Last edited by phobiaphobe; 07-15-2005 at 2:52 PM.
phobiaphobe is offline  
post #12 of 14 Old 07-15-2005, 2:54 PM
dB
 
Join Date: 04-17-2002
Posts: 1,666
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 0
   
Re: Quick Excel Question

If the number of days is equal to or less than 70, the cell will be blank. You can put whatever you want between the empty quotes at the end of the formula to cover this condition.

Is it not working?

edit: Nevermind, I see you changed your post. Glad I could help. You may still be able to use the info above.

Last edited by dB; 07-15-2005 at 2:56 PM.
dB is offline  
post #13 of 14 Old 07-15-2005, 2:56 PM
 
Join Date: 07-25-2002
Posts: 4,668
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 0
             
Re: Quick Excel Question

Quote:
Originally Posted by dB
Check out the DAYS360 function.



I'm sure RRWANTR or "PETE" will be here shortly to give you the 5 character solution.



Last edited by RRWANTR; 07-15-2005 at 2:57 PM.
RRWANTR is offline  
post #14 of 14 Old 07-15-2005, 2:59 PM
 
phobiaphobe's Avatar
 
Join Date: 05-23-2004
Location: Omnipresent
Age: 37
Posts: 11,499
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Reputation Power: 43
                     
Send a message via MSN to phobiaphobe
Re: Quick Excel Question

Quote:
Originally Posted by dB
If the number of days is equal to or less than 70, the cell will be blank. You can put whatever you want between the empty quotes at the end of the formula to cover this condition.

Is it not working?

edit: Nevermind, I see you changed your post. Glad I could help. You may still be able to use the info above.
FOr a "false" value I just put "OK". Works perfectly, thanks.

And then there's this asshole...
phobiaphobe is offline  
Reply

  Lower Navigation
Go Back   Honda Motorcycles - FireBlades.org > Other > Off-Topic

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Honda Motorcycles - FireBlades.org forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
A valid e-mail address is REQUIRED. You will not have access to any site features until you activate your account using the activation e-mail that is sent to this address.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need quick help...header install question???? tglass Honda FireBlade 3 05-23-2005 10:59 PM
Under Armor quick question, need an answer quick! deez Riding Gear / Luggage 14 07-15-2004 6:14 PM
Quick question about 1000rr exhaust DWC392 Honda FireBlade 5 06-11-2004 12:41 PM
quick brake question... Goose Honda FireBlade 7 05-25-2004 1:13 PM
Quick Question Maybe? juice Honda RC51 8 04-01-2004 9:10 AM

Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

 
For the best viewing experience please update your browser to Google Chrome