software

I Designed A Spreadsheet Which Has Today's Date In Column A, Purchased
Date In Column D, Difference Between The Two Dates In Column E, And
Column F Determines If The Item Is Still Under Warranty Or Needs To Be
Referred To The Service Department (1 Year Warranty). My Formula Works
Great Because It Calculates The Difference In Today's Date And The
Purchase Date, It Decides If It Is Less Than Or More Than 365 Days, If
Less, It Reflects The Word quot;warrantyquot; In Column F And Highlights In
Blue And If More, It Reflects The Word quot;servicequot; In Column F And
Highlights In Red. Now ... Here Is My Dilemma. When I Copy The
Formula Down To The Rest Of The Spreadsheet So I Can Send To My
Facilities Manager, It Defaults Column F To Warranty. Granted, If I
Enter Information And It Should Be Service, It Changes, But It Shows
Warranty All The Way Down The Spreadsheet When There Is Nothing Entered
Yet On The Blank Rows. How Do I Get It To Not Put Anything In These
Rows Until There Are Dates Entered.--
denhar
------------------------------------------------------------------------
denhar's Profile: www.excelforum.com/member.php...oamp;userid=24089
View this thread: www.excelforum.com/showthread...hreadid=504279Well, likely, your formula is something like =if((d1-a1)lt;365,quot;Warrantyquot;,quot;quot;)
It needs to be something like
=if(isblankd(a1),quot;quot;,if(d1-a1)lt;364,quot;Warrantyquot;,quot;quot;)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;denharquot; gt; wrote in
message ...
gt;
gt; I Designed A Spreadsheet Which Has Today's Date In Column A, Purchased
gt; Date In Column D, Difference Between The Two Dates In Column E, And
gt; Column F Determines If The Item Is Still Under Warranty Or Needs To Be
gt; Referred To The Service Department (1 Year Warranty). My Formula Works
gt; Great Because It Calculates The Difference In Today's Date And The
gt; Purchase Date, It Decides If It Is Less Than Or More Than 365 Days, If
gt; Less, It Reflects The Word quot;warrantyquot; In Column F And Highlights In
gt; Blue And If More, It Reflects The Word quot;servicequot; In Column F And
gt; Highlights In Red. Now ... Here Is My Dilemma. When I Copy The
gt; Formula Down To The Rest Of The Spreadsheet So I Can Send To My
gt; Facilities Manager, It Defaults Column F To Warranty. Granted, If I
gt; Enter Information And It Should Be Service, It Changes, But It Shows
gt; Warranty All The Way Down The Spreadsheet When There Is Nothing Entered
gt; Yet On The Blank Rows. How Do I Get It To Not Put Anything In These
gt; Rows Until There Are Dates Entered.
gt;
gt;
gt; --
gt; denhar
gt; ------------------------------------------------------------------------
gt; denhar's Profile:
gt; www.excelforum.com/member.php...oamp;userid=24089
gt; View this thread: www.excelforum.com/showthread...hreadid=504279
gt;

No, my formula is:
=IF((A2-D2)gt;365,quot;SERVICEquot;,quot;WARRANTYquot;)--
denhar
------------------------------------------------------------------------
denhar's Profile: www.excelforum.com/member.php...oamp;userid=24089
View this thread: www.excelforum.com/showthread...hreadid=504279Okay, so...
=if(isblankd(a2),quot;quot;,if(a2-d2)gt;365,quot;Servicequot;,quot;Warrantyquot;,quot;quot;)
If D column is filled in before A column, you may need this:
=if(or(isblank(a2),isblank(d2)),quot;quot;,if(a2-d2)gt;365,quot;Servicequot;,quot;Warrantyquot;,quot;quot;)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;denharquot; gt; wrote in
message ...
gt;
gt; No, my formula is:
gt; =IF((A2-D2)gt;365,quot;SERVICEquot;,quot;WARRANTYquot;)
gt;
gt;
gt; --
gt; denhar
gt; ------------------------------------------------------------------------
gt; denhar's Profile:
gt; www.excelforum.com/member.php...oamp;userid=24089
gt; View this thread: www.excelforum.com/showthread...hreadid=504279
gt;

no - I fill in A2 before D2--
denhar
------------------------------------------------------------------------
denhar's Profile: www.excelforum.com/member.php...oamp;userid=24089
View this thread: www.excelforum.com/showthread...hreadid=504279