AnsweredAssumed Answered

Calculate Value based on a number..

Question asked by linuxpad on Dec 9, 2012
Latest reply on Dec 10, 2012 by linuxpad

Title

Calculate Value based on a number..

Post

     Developers..

     Bare with me as I am new here..  

     I am looking to change a field based on totals of another field.  I have all the formulas working execpt the last one.

     If ( weight_lifted  <="1095";"0 Degree Angle";If (weight_lifted <= "1252";"22 Degree Angle"; If (weight_lifted  <= "1506";"30 Degree Angle";If (weight_lifted  <= "2122";"45 Degree Angle";If (weight_lifted  <= "3240";"60 Degree Angle";If (weight_lifted  <= "5790";"75 Degree Angle";If (weight_lifted  <= "8583";"80 Degree Angle";If (weight_lifted  >= "8584";"To Much Weight"))))))))

     Here is what I am attemping to do..  if the value of the field is less than 1095 show 0 degree angle..

     Here is the problem  If the value is 11095 is still shows 0 degree angle..  Any advice?

     Thanks in advanced,

     JP

Outcomes