ExcelBanter - Help with IF?

ExcelBanter (https://www.excelbanter.com/)

- About this forum (https://www.excelbanter.com/about-forum/)

- - Help with IF? (https://www.excelbanter.com/about-forum/446910-help-if.html)

LostGirl1000

Help with IF?

Hi Guys

I am having trouble with what I feel should be an easy formula - bascially I think i need an 'if' formula:
c2 = 3/5/12 (date)
c3 = 3/8/12 (date)
if we have gone passed c3 date i need 'backlog' if we have not passed c3 we are 'ok'

I tried =if(c3=0, "ok","backlog") but it doesnt seem to work

There is a 90 day rule from c2

Thanks

Spencer101

Quote:

Originally Posted by LostGirl1000 (Post 1604838)

Hi, try the below formula. Is this what you mean?

=IF(C3<TODAY(),"Backlog","OK")

LostGirl1000

Quote:

Originally Posted by Spencer101 (Post 1604862)

Hi, try the below formula. Is this what you mean?

=IF(C3<TODAY(),"Backlog","OK")

Thank you so much - it may have been a 'suck eggs' question but It was driving me crazy. You star !

Spencer101

Quote:

Originally Posted by LostGirl1000 (Post 1604863)

Thank you so much - it may have been a 'suck eggs' question but It was driving me crazy. You star !

Glad to help! :)

All times are GMT +1. The time now is 04:21 PM.