Forum Discussion

Saxon10's avatar
Saxon10
Post Prodigy
5 years ago
Solved

IF & AND Statement

RULE I have a length, width and height in column A,B,C and column D has unit of dimension I am trying to calculate volume in M3 based on the column D and dimension (length, width and he...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Saxon10 

    use the below query as per your excel formula. If condition is good to use. Tweak your calculation as per your requirement. Plesae cehck, The formula doesn't need to devide by 1k if the UOM is "M"

    _dimRes = 
IF(ISBLANK([UOM]),BLANK(),
            IF([UOM] = "CM", [L]*[W]*[H]/1000000,IF([UOM] = "MM", [L]*[W]*[H]/1000000000,IF([UOM] = "M", [L]*[W]*[H]/1000))))

     

Saxon10's avatar
Saxon10
Post Prodigy
5 years ago

I am trying to attempting IF/AND function but I am receiving error.