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,"")
