04-26-2019 03:22 AM
04-26-2019 03:49 AM
By the way, that is common but, from my point of view, not quite good idea to return empty text ("") instead of zero to show the value as blank. Better to avoid mix of texts and numbers in one column. If one day you decide to do any calculations on column H you may receive an errors. SUM and some other functions ignore texts, but, for example, if take some percentage in column I when =H4*5% returns an error if you have empty text in H4.
To show zeroes as blanks it could be using the setting in File->Options->Advanced->Dispaly options for worksheet. Even better to apply custom format General;General; or similar for not showing zeroes.
by Bill Jelen on February 26, 2020
Posted in Microsoft Ignite The Tour 2019 on October 10, 2019