AnsweredAssumed Answered

Calculate Lenght*Width*Height even if one of them is null

Question asked by Mirel on Jan 18, 2009
Latest reply on Jan 19, 2009 by Mirel

Title

Calculate Lenght*Width*Height even if one of them is null

Post

Ciao!

 

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!

 

 

Outcomes