Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel, date-sensitive, 2-part formulas
I am trying to figure out a formula for billing in Excel 2003.
I want to be able to enter # of pmnts based on date. So far I have: =if(b239217,3,2) meaning: if date (b2) is greater than 5/14/07, 3 payments, otherwise2. BUT I also want to say: AND if the dates in B2 are less than 5/1/05, 1 pmnt. Anyone can help? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sensitive Formulas | Excel Discussion (Misc queries) | |||
How to set up a date sensitive notification? | Excel Discussion (Misc queries) | |||
How to set up a date sensitive notification? | Excel Discussion (Misc queries) | |||
Date sensitive cells | Excel Discussion (Misc queries) | |||
Trying to make cell "date sensitive" to specific date | Excel Discussion (Misc queries) |