Thread: if condition
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Malik Nadeem Malik Nadeem is offline
external usenet poster
 
Posts: 44
Default if condition

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