Thank you MandyThat helped very much, after I took the time to understand the code it made sense. I was able to code up the rest of my requirements and evertything worked beautifully. Thank you very much.

Thanks for the reference docs. I shall download them now, from glance I think I have 2 of them already... lengthy readingA follow on question to the above; If I have a radio button with 2 options and I wanted to execute one of two IF statements based on the radiobutton selection how might I do this?...

Thank you JonoI was also missing the second mention of the numericfield1 after the 'and'. Starting to make more sense now.My gratitude reaches out to you

I am looking for help with an IF statement that looks at value ranges and performs a sum based on what it finds.I am using LC D 8, script is running on FormCalc - Client side - Calculate event. Numericfield1 is a user entered value.I currently have (which doesn't work):if ( numericfield1 >= 1000 <= ...

I have solved this issue; The formular required in LiveCycle to replicate a MS Excel formular of: =IF(AG36=1,"5",IF(AG36>0.97,4,IF(AG36>0.84,"3",IF(AG36>0.3,"2","1"))))was: (Note 'Objectives_subform.Table1.Row9.Cell5' is equivelant to 'AG36' in Excel)  IF(Objectives_subform.Table1.Row9.Cell5 >= 100,...

Hello again, I have an update to this question...In LiveCycle, if I use Formcalc and set the field (numeric) to Calculate and enter this formular;  IF(Objectives_subform.Table1.Row9.Cell5 >= 100, "5",)I can achieve part of my goal. However I want to use four IF statements in the same formular and LC...

HelloI would like to replicate a microsoft Excel 'if' statement in a Livecycle form.The excel statement is: =IF(AG36=1,"5",IF(AG36>0.97,4,IF(AG36>0.84,"3",IF(AG36>0.3,"2","1"))))Which is based around %. The 1 in this statement equals 100%, then the 0.97 would be 97% and so on...AG36 is a cell in Exc...