Team,
Working on a spread sheet that is calculating the expected return date by number of pages and date turned in. Current formula:
=IF(I3<=0,"",IF(I3=5,"2"+B3,IF(I3<50,"3"+B3,IF(I3>=50,"14"+B3))))
Formula breakdown
IF(I3<=0 (Zero pages to keep the "FALSE" from appearing)
IF(I3=5 (5...