|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
October 27th, 2007, 09:48 AM
|
|||
|
|||
General Question - Excel Formula help
Hey all, I was directed here from google. I have a fairly simple excel formula problem I am hoping someone here can help me with. If I have a date in cell C-1, I want cell A-1 to say PAID, if there is no date I want Cell A-1 blank. I have been playing around with it for awhile and can't seem to get it right. Thanks in advance for your help.
|
|
#2
October 28th, 2007, 02:43 AM
|
||||||
|
||||||
|
ummm, in A1, put =IF(C1>=datevalue("1/1/2007"),"paid","")
of course, you can substitute the 1/1/2007 with any date you want, A1 will display paid for any date on or after 1/1/2007 in C1 in this case. I would set the date that it tests against to the very beginning date that it could possibly be, for example if your spreadsheet starts from 1/1/2003, then that would be the test date. Last edited by sbenj69 : October 28th, 2007 at 03:40 AM.
|
|
| Viewing: ASP Free Forums > Other > ASP Free Lounge > General Question - Excel Formula help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
