<HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message -->Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Would any of you Excel wizards be able to write a formula to carry out this very complicated scenario please :<o></o>
<o></o>
When cell A3 does not equal "NVQ" :<o></o>
<o></o>
Thank you in advance for your help.<o></o>
<o></o>
Pervis2k<o></o>
<o></o>
Would any of you Excel wizards be able to write a formula to carry out this very complicated scenario please :<o></o>
<o></o>
When cell A3 does not equal "NVQ" :<o></o>
- If the month and year value in cell F3 is less than that in the date value in cell C3 or is greater than the date value in cell D3 return the value "No Payment Expected".<o></o>
- If the month and year value in cell F3 is greater than that in the date value within C3 but equal to or less than the month within cell D3 divide the value in cell B3 by 1+cell E3 (for instance if the cell value in E3 = 5 then I need the formula to divide by 6).<o></o>
- If the month and year value in cell F3 is equal to the month and year in the date within cell C3 divide the value in cell B3 by 1+cell E3 and then multiply by 2.<o></o>
- If the month and year value in cell F3 is less than that in the date value in cell C3 or is greater than the date value in cell D3 return the value "No Payment Expected".<o></o>
- If the month and year value in cell F3 is greater than that in the date value within cell C3 but is less than the month in the date within cell D3 divide 75% of the value in cell B3 by 1+cell E3.<o></o>
- If the month and year value in cell F3 is equal to that in the date value within C3 divide 75% of the value in cell B3 by 1+cell E3 and then multiply by 2.<o></o>
- If the month and year value in F3 is equal to that in the date value within D3 divide 75% of the value in cell B3 by 1+cell E3 and then add on 25% of the value of cell B3.<o></o>
<o></o>
Thank you in advance for your help.<o></o>
<o></o>
Pervis2k<o></o>