I have a formula:
=TEXT(B48,"###")&" transactions ("&TEXT(D48,"+0%;-0%;0%")&" m/m)"
This should pull in something like this:
15 transactions (-50% m/m)
However, if cell B48 is 0, it doesn't pull in the 0 and I'm left with something like:
transactions (-100% m/m)
How do I set this up so that it pulls in the 0?
Bookmarks