View Single Post
  #1   Report Post  
capiche
 
Posts: n/a
Default IF Function Help


Hi Guys,

I'm a NEWB. Nice Forum.

I'm making a worksheet and I'm having problems with the "IF" function.
I'll explain what I'm doing and if you wouldn't care, please help. :)

I'm just making a worksheet of my domain portfolio. I have the "dates
registered" and "expiration dates" beside each domain name. I also have
the "Today" function running in cell C1 on top of the worksheet.
What I want to do, is create an if string for each "expiration date"
saying, IF C1 equals a certain date, then change the expiration date to
"RENEW", IF it doesn't equal that date, I just want it to stay the
same.

Could anyone tell me how to do this?

Hope this makes sense.
Thanks,
Scott


--
capiche
------------------------------------------------------------------------
capiche's Profile: http://www.excelforum.com/member.php...o&userid=26697
View this thread: http://www.excelforum.com/showthread...hreadid=399633