Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I need your help on this formula I need to calculate Storage Fees Column (A) Date In Column (B) Date out Column (C) numbers of days in Stock (A1-B1)=112days The First ten days free The fees on First 20 days after the 10days = 1 dollar The fees on second 20 days after the 10days and 20 day = 2 dollar The fees on Third 20 days after the 10days,20day and 20day = 3 dollar The fees on remaining days after the 10days, 20day, 20day, and 20 day = 10 dollar Date In Date out Numbers of days 05/11/2008 25/02/2009 112 Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Jululian | Excel Discussion (Misc queries) | |||
Excel Jululian | Excel Discussion (Misc queries) |