if condition

[Malik Nadeem]

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

 

[Pete_UK]

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

 

[David Biddulph]

Repair that Caps Lock key so that you can stop SHOUTING, and try again.

 

[Jarek Kujawa]

Yep, Mr. rude...

 

[Malik Nadeem]

Yep, Mr. rude...

===============================

yes you are right its my mistake sorry for inconvenience.
my question is as under.
==============================
unit rcvd (total days till to date) free days no of
units amount in pkr
5-nov-08 65 (09-jan-209) 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

once again regert for inconvenince

 

[Malik Nadeem]

yes you are right its my mistake sorry for inconvenience.
my question is as under.

once again i am repeating my question

A B C D
E
-----------------------------------------------------------------------------
05-nov =now()-a1 5 1
(result i need here)
----------------------------------------------------------------------------
05-nov 65 5 1
258000
----------------------------------------------------------------------------

in a column E will work like this

* condition # 1
if column B1 is less then or equal to 5 then cell E1 showing "FREE"

* 2nd condition in a same cell E1
if column B1 is grater then 5 then (B1-C1) i.e. equal to 3
now this 3 result multiply with D1 and multiply with $80 per day mean
2days=160, 3 days=240, 4 days=320 & 5 days=400 stop here
in above condition 3 days mean = $240
now (3*80*D1)or(240*D1) till the value is less or equal to 5
example
A B C
05-jan 08 5 = free till 10/jan (rest days 3)
=D1*(if value 1=80, 2=160, 3=240, 4.....5=400)
A=unit rcvd date
B=(=now()-A1)
C=free days
D= total units

* 3rd condition
if value grater then 5 and less then or equal to 10 it should be work like
this
(1st 5 days calulating like condition # 2 itself
but on 6 day it will charge 160 per day)

example
1st 5 days 80 per day
next 5 days 160 per days
after this per day charges will be 320

result
charging of 13 days
0-5 days = 400 (80 p/day)
6-10 days = 800 (160 p day)
11-.... days = 320 per day................

total 13 days result is (400+800+960)=2160

i realy thankful that person who can help me out to make a such kind of
conditional formula

regards
Malik Nadeem