Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 05-16-2013, 08:29 AM   #1
Fully Optimized
 
jmacavali's Avatar
 
Join Date: Jun 2009
Posts: 4,867
Default Excel Formulas

I might have to go to an excel forum, but thought I'd try here first.

I have this formula:
=IF([@IMAGED]<>"",TODAY()-[@IMAGED],"")
where it looks at the "imaged" column and then figures out how long it's been since the computer was imaged. The result in the column is "xx days".

I copied the formula to another column and changed 2 words:
=IF([@PURCHASED]<>"",TODAY()-[@PURCHASED],"")
so that I could do the same thing to calculate how long it's been since the computer was purchased. The result in the column is "xx". What's missing is the word "days".

I have no idea where it comes from in the first formula and why it doesn't show up in the second. Any thoughts anyone?
__________________

__________________
****************************************
Don't take life too seriously -- no one gets out alive. Plus, who wants to arrive to the hereafter in pristine condition wearing a suit and tie?
I want to slide in sideways, worn out, used up, hair a mess, clothes tattered, & screaming, "Whooo! What a ride!"
****************************************
jmacavali is offline   Reply With Quote
Old 05-16-2013, 09:02 AM   #2
Fully Optimized
 
jmacavali's Avatar
 
Join Date: Jun 2009
Posts: 4,867
Default Re: Excel Formulas

There is a custom format you can use that will add 'days' to the end of whatever is in the cell. Since it had been many months since I did the first column I had forgotten all about it. Found it and it's good now.
__________________

__________________
****************************************
Don't take life too seriously -- no one gets out alive. Plus, who wants to arrive to the hereafter in pristine condition wearing a suit and tie?
I want to slide in sideways, worn out, used up, hair a mess, clothes tattered, & screaming, "Whooo! What a ride!"
****************************************
jmacavali is offline   Reply With Quote
Old 05-16-2013, 09:47 AM   #3
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 1,935
Default Re: Excel Formulas

Glad you found it and thanks for posting the solution!
strollin is offline   Reply With Quote
Old 05-17-2013, 08:18 AM   #4
Golden Master
 
BK_123's Avatar
 
Join Date: Dec 2009
Location: Australia
Posts: 7,528
Default Re: Excel Formulas

I hate using formulas in Excel :/
BK_123 is offline   Reply With Quote
Old 05-17-2013, 09:24 AM   #5
Wizard of Wires
 
setishock's Avatar
 
Join Date: Feb 2005
Location: Not sure
Posts: 10,030
Default Re: Excel Formulas

I've made several spread sheets to ease the paperwork here at the hotel. Formulas are fairly straight forward when doing the less complicated stuff like payroll and the daily reports.
The macros are what blows my mind.
setishock is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not 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 On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 11:49 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0