if nested formulas

M

marleneardon

Column A column B column C column
D

Date Due Date Returned Fine
Adams(row 4) 10/10/2002 10/12/2002
Brown(row 5) 10/11/2002 10/17/2002
Davis (row 6) 10/30/2002 11/12/2002


Fine Chedule

0.25 (column D,row 7)
1.00 (column D , row 8)



I need to know what formula to put on column D; I need to find the fine
they'll charged me for returining books late.

if a book is returned no later than three days after due date ( or: 4 days
including the due date, no fine.
if a book is returned beyond three days but within 7 days after due date,
fine is a quarter per day:
if a book is retruned beyond 7 days after due date, the fine is a dollar per
day. thank you
 
P

paul

=IF(C5-B5<=4,0,IF(AND(C5-B5>4,C5-B5<=7),0.25*(C5-B5),C5-B5))
this will work unless you need to exclude weekends or holidays
 
Top