9 Replies Latest reply on Jan 19, 2009 4:44 AM by Mirel

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

    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!