UNIT RCVD TODAL DAYS TILL TO DATE FREE DAYS NO OF UNITS AMOUNT IN PKR
5-Nov-08 69 5 1 400

I NEED THE FORMULA CONDITION OF IF WHICH WILL WORK LIKE THIS
TOTAL NUMBER OF DAYS 65
FREE DAYS 5
REST DAYS 60
NOW IN A COLUMN E WE NEED RESULT PKR 258000 AUTOMATICALLY WHICH WILL WORK
LIKE
1ST 5 DAYS = PKR 80 NEXT 5 DAYS = PKR 160 AFTER 10 DAYS FIX AMOUNT PKR=320

ABOVE CHARGES ARE P/DAY CHARGES

EXAMPLE
1ST 5 DAYS WHICH WILL START FROM 10-NOV-2008 = 80 X (TOTAL NUMBER OF
UNITS) X PKR 80
NEXT 5 DAYS WHICH WILL START FROM 15-NOV-2008= 160 X (TOTAL NUMBER OF
UNITS) X PKR160
AFTER THIS IF DAYS LEFT IT CAN MULTIPLY WITH PKR 320 TILL END

RESULT
AMOUNT (TOTAL UNITS) UPTO 14-NOV = 6000 PKR
AMOUNT ( C4 ) UPTO 19-NOV=12000 PKR
AMOUNT ( C4 ) UPTO TODAY/08-NOV = 240000 PKR

TOTAL 258000