if condition
Many people are put off when they see a post all in upper-case. It is
difficult to read, and is also considered rude.
You might get more responses if you avoid this SHOUTING.
Pete
On Jan 12, 4:12*pm, Malik Nadeem
wrote:
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
|