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,"-"))))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks