For example, this is what I'm doing currently (simplified the calculation for clarity):
if(A1*B1 < 1, "", A1*B1)
This works fine but isn't there a way to simply return the calculation without having to repeat it manually as one of the returns?
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 285 |
Nodes: | 16 (2 / 14) |
Uptime: | 71:54:56 |
Calls: | 6,488 |
Calls today: | 1 |
Files: | 12,096 |
Messages: | 5,275,729 |