MrExcel Publishing
Your One Stop for Excel Tips & Solutions

if/then formula


Posted by Strebeck on November 12, 2001 12:58 PM

In a month by month mortgage spreadsheet I have in Column A the month number (1 through 360), Column B is the decreasing loan balance, Column C is the increasing balance of an investment. The formula I seek is: In what month does the balance in Column C FIRST exceed the balance in Column B? (IF the value of C > value of B then insert the value of A in this cell.)
Thanks for any help.


Posted by faster on November 12, 2001 1:04 PM

I think this is what you asked for:

Paste it in D2

=IF(C2>B2,A2,"")