=PMT(D33/$AA$33,E33*$AA$33,-C33)
On other cells with this formula, if for example, D,E, and C33 are blank, it comes back as error, need it to show a dash and no error.
=PMT(D33/$AA$33,E33*$AA$33,-C33)
On other cells with this formula, if for example, D,E, and C33 are blank, it comes back as error, need it to show a dash and no error.
can use iferror.
Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks