AnsweredAssumed Answered

Nested if calculation problem

Question asked by zaza on Apr 1, 2013
Latest reply on Apr 1, 2013 by philmodjunk

Title

Nested if calculation problem

Post

     I am trying to set up text formatting colour change to specified values but i keep getting 'too many parameters' error.

     the formula so far is:

If ( curr_property  ≥ 360 and 600 ; TextColor ( curr_property ; RGB ( 255 ; 153 ; 204 ; If ( curr_property  ≥ 600 and  ≤ 999 ; TextColor ( curr_property ; RGB ( 255 ; 204 ; 0  ; If ( curr_property  ≥ 1000 ; TextColor ( curr_property ; RGB ( 221 ; 8 ; 6  ; curr_property ) ) 

     Have I used the wrong operators, too many brackets?

     Any help will be appreciated.

Outcomes