nesting formulas

[Vladimir]

I'm trying to get this formula to work.

=IF(OR(K2="L",K2="M",E2<=10),120,60,IF(OR(K2="L",K2="M",E2=11,E2=12,E2=13,E2=14),90,60,IF(OR(K2="L",K2="M",E2=15,E2=16,E2=17),45,45,IF(OR(K2="L",K2="M",K2="H",E2>17),30,30))))


But it tells me that I have too many arguements within the function.

The problem is they are required to get the answer I am looking for. What
I'm asking is: If column K has an L or M and column E is <=10, then the value
is 120, if false, 60. If in K, L and M are equal to 11 through 14 in column
E, then the value is 90 and if false 60, IF in column K, L and M are equal to
15-17 in column E then the answer is 45 and if not it is 45, and if in column
K, L and M are greater than 17 in column E, then the answer is 30 and if mot
it is 30.


Please Help

 

[Dave F]

Yeah you have too many arguments, starting with the first IF clause.

You're saying "If (K2 = L OR M) OR (E2 is less than or equal to 10), THEN
120, ELSE 60"

Then you have another IF clause....

Nested IFs have to work like =IF(Condition 1,Then Do X, Else If(Condition 2,
Then Do...)

See the difference?