undefined

[Anonymous]

Hi,

I have 4 different columns i.e. standard weight, actual weight, +2%of standard weight, -2%of standard weight.

now i want to calculate the weight status. That weight is between the permisible limits or not.

Weight Status = IF(weight[standard_WT_-2%]<weight[Actual_WT]<weight[standard_WT_+2%],"Ok","Not Ok")

Kindly help

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Please explain clearly the logic of what you want

Try it like this

Weight Status = IF( AND( weight[standard_WT_-2%] < weight[Actual_WT] , weight[Actual_WT] < weight[standard_WT_+2%]), "Ok" , "Not Ok")

Regards

Phil

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Please explain clearly the logic of what you want

Try it like this

Weight Status = IF( AND( weight[standard_WT_-2%] < weight[Actual_WT] , weight[Actual_WT] < weight[standard_WT_+2%]), "Ok" , "Not Ok")

Regards

Phil

[Anonymous · Accepted solution]

Thanks @PhilipTreacy . This is exactly i wanted.