Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if condition
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if condition
Repair that Caps Lock key so that you can stop SHOUTING, and try again.
-- David Biddulph "Malik Nadeem" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if condition
Yep, Mr. rude...
On 12 Sty, 18:44, "David Biddulph" <groups [at] biddulph.org.uk wrote: Repair that Caps Lock key so that you can stop SHOUTING, and try again. -- David Biddulph |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
if condition
"Jarek Kujawa" wrote: Yep, Mr. rude... On 12 Sty, 18:44, "David Biddulph" <groups [at] biddulph.org.uk wrote: Repair that Caps Lock key so that you can stop SHOUTING, and try again. -- David Biddulph =============================== 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More condition | Excel Discussion (Misc queries) | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
if condition | Excel Discussion (Misc queries) | |||
Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
Condition 1 overules condition 2? | Excel Worksheet Functions |