IF Function Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

capiche - 26 Aug 2005 22:51 GMT

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 "date
registered" and "expiration dates" beside each domain name. I also hav
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 t
"RENEW", IF it doesn't equal that date, I just want it to stay th
same.

Could anyone tell me how to do this?

Hope this makes sense.
Thanks,
Scot

Reply to this Message

Sandy Mann - 26 Aug 2005 23:43 GMT

Assuming that the "Expiration Date" is not manually entered but calculated
then with the "Date Registered" in A1, for a number of days try:

=IF(A1+20<C1,"Renew",A1+20)

For a number of Months try:

=IF(DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))<C1,"Renew",DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)))

Although note that three months on to August 31st will be December 1st not
30th November. If you want the last day in the month then post back

Signature

HTH

Sandy
sandymann@mailinator.com
Replace@mailinator with @tiscali.co.uk

> Hi Guys,
>
[quoted text clipped - 16 lines]
> Thanks,
> Scott

Reply to this Message

capiche - 27 Aug 2005 15:26 GMT

Thanks for the input. All of the Expiration Dates -are- manuall
entered. The only non-static date is C1 which changes daily. As today'
date grows closer to a names expiration date, (like within a month o
it), I would like the expiration date to change to "RENEW", just as
reminder to me when I open the worksheet.

Will your formula still work with these static dates?

Thanks a lot for helping out. I don't know a lot about Excel. Obviou
huh? :rolleyes

Reply to this Message

Sandy Mann - 27 Aug 2005 17:42 GMT

capiche,

No you can't have a manually entered date and a formula in a cell at the
same time - entering a date will overwrite the formula.

If you choose a cell adjacent to the expiration date then you can get it to
give the warning or appear blank until that time:

=IF(A1+20>C1,"Renew","")

for a number of days until the renewal date

=IF(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))>C1,"Renew","")

for a month before the renewl date.

Signature

HTH

Sandy
sandymann@mailinator.com
Replace@mailinator with @tiscali.co.uk

>
> Thanks for the input. All of the Expiration Dates -are- manually
[quoted text clipped - 7 lines]
> Thanks a lot for helping out. I don't know a lot about Excel. Obvious
> huh? :rolleyes:

Reply to this Message