LinkBack URL
About LinkBacks
i have added a new column that contains the difference between the two dates
i need to know who i would go about using an if function to add the amount of penalty into the next column automatically.
i have added a new column that contains the difference between the two dates
i need to know who i would go about using an if function to add the amount of penalty into the next column automatically.
just can't figure out how to get the penalty to work there
Assuming late % to be calculated in G12 onwards
formatted as %
G12: =IF($A12="","",LOOKUP(MAX(0,F12-$G$1),{0,7,14,21,28},{0,0.1,0.2,0.3,1})) copied down
not entirely sure I followed the date requirements - you may want {0,1,8,15,22} rather than {0,7,14,21,28}
Last edited by DonkeyOte; 12-01-2009 at 06:52 AM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
works perfectly
thanks allot sorry about the repost couldn't find the original thought it got deleted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks