I am trying to make a conditional formula from 7 range of cells. The two has
different condition, and the remaining five has the same condition. I tried
doing it individually, but when it came to the seventh and last cell, it
doesnt accept it. Is it because I can only do so much function in a
formula(it says not more than seven)? If so, is there any way I can just do
the last five cells at once since the condition is all the same for the last
five range of cells? This is my what I was trying to do:

=if(g5=k52,rounded(sum(k22:k25)*80%,0),if(g5=k53,r ounded(sum(k22:k25),0),if(g5=k54,rounded(sum(k22:k 25)*85%,0), if....so on and so forth up to k58

From k54 to k58, the conditions are the same which is 85% of the total of
k22 to k25 rounded off.

Please help.

Irene