I have an if statement that if true, looks up a table in nav and returns a vendor name based on a vendor number.However, if the cell with the vendor numbe ris blank then the result is value#.I want to get rid of value and instead have text "journal".This is straight forward in excel if statement ,but it does not work in jet reports.
THIS IS WHAT I HAVE
=IF(B41="","",NL("Rows","Vendor","Name","No.",$D41)) i SHOULD BE ABLE TO HAVE THE FALSE AND WRITE , "JOURNAL"
but it does not work
Date
Votes
1 comment
-
Jet Reports Historic Posts Does it work if you enter this…
=IF(B41="","Journal",NL("First","Vendor","Name","No.",$B41))
Please sign in to leave a comment.