How to key a formula to compute the due date

**jamesoc79** · 05-14-2009, 04:04 AM

Can't seem to find the way to do it. Thanks for your help.

**squiggler47** · 05-14-2009, 04:05 AM

The formula I gave you works it will give the days late, if its not late it will give 0!

**squiggler47** · 05-14-2009, 04:09 AM

here is moddes sheet

**jamesoc79** · 05-14-2009, 04:22 AM

this assignment is very confusing to me. It said in cell F4, create an IF formula. The first logical test is that cell E4 be greater than 120 days. If this is so, the Value_if_true is Over 120. As the Value_if_false, nest another IF function. The logical test for the second IF function is that cell E4 be greater than 60. The Value_if_true for this IF statement is Over 60. the Value_if_false entry for the second IF statement is Acceptable. Right-align the results, and copy the formula.

**squiggler47** · 05-14-2009, 04:41 AM

Originally Posted by jamesoc79

this assignment is very confusing to me. It said in cell F4, create an IF formula. The first logical test is that cell E4 be greater than 120 days. If this is so, the Value_if_true is Over 120. As the Value_if_false, nest another IF function. The logical test for the second IF function is that cell E4 be greater than 60. The Value_if_true for this IF statement is Over 60. the Value_if_false entry for the second IF statement is Acceptable. Right-align the results, and copy the formula.

What's confusing, it basically tells you what to do!

type =if(
then press the small fx on the formula bar!

read the boxes!