IF statement for long values list
-
Hi, I have read all posts about this IF conditional statement. But when I try with long list of values, works just first condition.
My formula is:
“IF((id_1 + id_2 + id_3 + (id_4*2) + (id_5*2) + (id_6*5) + (id_7*3) + (id_8*10) + (id_9*10) + (id_10*5) + (id_11*20))>220, id_1 + id_2 + id_3 + (id_4*2) + (id_5*2) + (id_6*5) + (id_7*3) + (id_8*10) + (id_9*10) + (id_10*5) + (id_11*20), IF((id_1 + id_2 + id_3 + (id_4*2) + (id_5*2) + (id_6*5) + (id_7*3) + (id_8*10) + (id_9*10) + (id_10*5) + (id_11*20))<220, id_1 + id_2 + id_3 + (id_4*2) + (id_5*2) + (id_6*5) + (id_7*3) + (id_8*10) + (id_9*10) + (id_10*5) + (id_11*20), 220))”So not I am not sure is the IF works for this.
You can view it on http://www.visanja.com/buhalteriniu-paslaugu-kainos-skaiciuokle
The topic ‘IF statement for long values list’ is closed to new replies.