Tech Support Guy banner
Cancel

Solved: Excel Nested IFs

862 Views 3 Replies 2 Participants Last post by  CodeLexicon, 
R
I am trying to create an IF formula in a retirement calculator that returns zero in column "K" ("Savings Open Balance") up until retirement age but then picks up column "J" (Closing Balance") in cell 'J23".....the problem is that after that, the "K" column must pick up the result of the "N" column amount in retirement closing balance to complete future money. I can't figure out how to reference both the relative J28 cells and the N24 cells as the retirement dates change.


refer to attachment.


Hope this is clear.

Attachments

Save
Like
Status
Not open for further replies.
1 - 4 of 4 Posts
CodeLexicon
If you put this formula in K20 and drag it down to K28 ...


=IF($D20=$C$11+1,$J19,IF($D20>$C$11+1,$N19,0))


So it is checking if the age is the year after retirement and returning the closing balance from the preceding year in Col J, or if older than 54, the closing balance from the preceding year in Col N ... or for years up to and including retirement, returning a 0
Save
Like
R
Duh!!!


It's pretty simple once you get your logic straight!!


I was trying (unsuccessfully) to use the J column closing balance as the trigger and it was running into itself. Using the age relative to the retirement date works like a charm.


Thanks much!
Save
Like
CodeLexicon
It's often the way with IF formulas that you need to home in on the simplest logic. If you've got your answer, you can mark the thread as solved :)
Save
Like
1 - 4 of 4 Posts
Status
Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Hardware Virus & Other Malware Removal Off Topic Lounge Thread Games & Discussion Networking
Top