Also when option not selected, shows a false, need to show a dash
=IF(D2="Auto Loan # 1",PMT(E9/E10,E8*E10,-E7,IF(D2="Auto Loan # 2",PMT(E9/E10,E8*E10,-E7,IF(D2="Auto Loan # 3",PMT(E9/E10,E8*E10,-E7,"-"))))))
Also when option not selected, shows a false, need to show a dash
=IF(D2="Auto Loan # 1",PMT(E9/E10,E8*E10,-E7,IF(D2="Auto Loan # 2",PMT(E9/E10,E8*E10,-E7,IF(D2="Auto Loan # 3",PMT(E9/E10,E8*E10,-E7,"-"))))))
In C2 Cell
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks