Thread: Multiple function not performing

Can anyone help me with a formula? Here's what I have and need:
J2 contains amount ($10).
K2 contains current year fees due amount ($120)
L2 contains new balance ($130) (by formula sum=J2+K2
M2 contains last payment amount ($10)
N2 contains last mayment date, always changing, can be 2010 or 2011.

Here's where I need the formula...

O2 If the date in N2 is after 1/1/2011 then sum:L2-M2. If not, then give sum (or total) in L2

Sample workbook attached

Hello, thanks for changing the title.

according to the brief, maybe


O2 If the date in N2 is after 1/1/2011 then sum:L2-M2. If not, then give sum (or total) in L2

=if(N2>1/1/2011,L2-M2,L2)

If that does not help, please post a workbook.

cheers,

That's changing all the totals in O regardless of the date. I think it may be looking at the first number in the date the 03 in 03/10/10, even though it's 2010, and still changing the total. Should I change the date Format to read the full date, as in March 10, 2010 and then it will look at only the year???

Hello,

this should do it in N2, copied down

=IF(N2>DATEVALUE("1/1/2011"),L2-M2,L2)

cheers,

Thank you!

I can also use

=IF(N2>DATE(2011,1,1),L2-M2,L2)

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save