LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 34
Default Date STOP Accumulator

The columns on which to perform the arithmetic are

Date in: The initiating date +24 hours
Organisation: DVLA
Date Claimed: Date
Storage charge: £15 p.d. absolute reference Z2 which starts 24hrs after
receipt
Payment 1: £80 if the vehicle is collected within 24 hours - absolute
reference AB2
Payment 2: Absolute reference AC2, £160 if the vehicle is collected 24 hrs
+, and therefore blanks Payment 1
The formula I have is:
=IF(L204="","",IF(AB204=80,"",IF(AND(L204="DVLA",A B204=""),$AC$2)))

I have 3 problems:
1. The formula above returns a FALSE value when L204 doesn't read 'DVLA'
2. I feel that a 'stop' command is needed somewhere to prevent a never
ending accumulation?
3. This formula: =IF(AND(L204="DVLA",P204=""),(TODAY()-A204)*$Z$2,"")
starts running the charges immediately rather than a day later.

Dan
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date formulas DRondeau Excel Discussion (Misc queries) 7 September 6th 06 09:53 PM
import /paste -stop automatic conversion of text 05-12345 to date artech Excel Discussion (Misc queries) 1 August 20th 06 09:09 PM
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
Can stop excel from converting value to date? desmond New Users to Excel 3 September 21st 05 01:36 PM
How do I stop excel automatically changing my date to 2005? zoemcb Excel Discussion (Misc queries) 6 April 30th 05 02:39 AM


All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"