Rob Collie has some fun with DIVIDE():
A blank cell in a report is sometimes a source of confusion for those human beings consuming our work. “What does a blank cell mean,” they ask. “It’s a division by zero,” we reply. “Wut,” they then ask. “Trust me,” we say, “you don’t want to see the alternative.” “But I don’t trust you, and now I don’t trust this whole report,” is what they sometimes say next – whether under their breath or out loud.
But “N/A” is a lovely value to display. It raises far fewer eyebrows. “Oh, it says our Profit Margin % for electric blankets sold in Cancun is “N/A” – I get it, we’ve never sold that product there.” No convo required.
Click through for the full story.