Hi,
I'm wondering if there is a function similar to "iferror" that will leave a cell blank if the result of its formula equals zero. I normally do something like:
if(A1-A2>0, A1-A2, "")
This gets tedious and difficult to follow with long and/or nested formulas, so I'm looking for a shortcut. Does such a thing exist?
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 349 |
Nodes: | 16 (0 / 16) |
Uptime: | 142:50:53 |
Calls: | 7,613 |
Calls today: | 1 |
Files: | 12,790 |
Messages: | 5,684,507 |