Calculate Lenght*Width*Height even if one of them is null
This is my first post here so... be kind please (not necessary actually)
So here is my problem, actually my firs in a very very long list (you're probably see all of those, I just want to make one thing at a time...)
I have 3 fields/cells (don't know the english name, stupid italian user:)) wich are width, lenght and height. I need the "total" field to calculate width*lenght*heght, even if one of those are null.
What I do now is Width*Lenght*Height but if one of these are null, then the result is 0 ( every number * zero equals zero...)
Hope somebody could help, thanks!