Hello all,
i have an NF function that returns the currency code however if it is blank no code is returned. How can i make the default (for blanks) to be USD?
many thanks
Date
Votes
1 comment
-
CascadiaDataworks There are two ways. The first will slow the report down and isn't recommended and the second involves adding and hiding columns.
1. Wrap the NF function in an IF statement that says something like =if(NF(.....)="","USD",NF(...)). This is not recommended as this will not allow Jet to group process the NF statements. Excel will need to evaluate each one, one by one and this can add a lot of time to your report.
2. Add a column to the right of your NF and put the IF statement there. =IF(E#="","USD",E#) when column E has the NF functions. Then hide the column with the NF function in it. This is the better performing option but for some reason, some report writers to not like having the hidden column for copy/paste reasons.
Please sign in to leave a comment.